live vs static

[Titanic]

can i create visuals with a live connection and with a excel data by creating relationships between them.

if not let me know what is the procedure for that.

[Thejeswar · Accepted solution]

Hi @Titanic,

In case of Live Connection it is not possible to use Multiple Datasources

Also until June version of Power BI Desktop, when ever you use a excel you should have to import the data to Power BI i.e. It works only in Import Mode.

May be will the latest July Version Update of Composte Models (preview feature), it might allow you to connect a excel file from Import Mode and others from a live connection. Not sure but, you should check on the same.

Here's a similar post on this

http://community.powerbi.com/t5/Desktop/Live-Connection-Limitation-Get-Data-Data-Pane-Relationships-...

[Titanic]

thanks @Thejeswar @prateekraina

[prateekraina]

Hi @Titanic,

Yes, with the recently released preview feature "Composite Models" it is possible.

Prateek Raina