Live Connection Limitation - Get Data, Data Pane, Relationships Pane

[SJacobs]

When a live connection is in place, is it possible to also connect to another data source?   We have established a live connection to a cube, however, we'd like to perform ad-hoc analysis using a combination a data, say from the cube and an excel workbook.  When the live connection is in place, we no longer are able to get data or manipulate data through the data and relationship panes.  Is there any workaround to this?

[mahimabedi]

My reports have been created using a live connection to a SSAS cube. Can I now change the connection from live to import?

[v-sihou-msft · Accepted solution]

@SJacobs

No, it's not possible. In POWER BI Desktop, when using live connection, you can only open connection to a single SSAS database. All underlying data and relationship is loaded, it's not supported to make any modeling change. For your requirement, you can only achieve them in import mode.

Regards,

[Anonymous]

Hi @v-sihou-msft,

Landed on your reply for a question I am after. I have already gone through the Security Whitepaper but did not get the answer I am after.

Allow me first state my understanding before asking the question:

When Data is in process, PBI Service will create a in-memory Analysis Service Dataset and dataset is loaded onto it. (Ref Section: Data In Process Page 16 Power BI Security Whitepaper released May 2017) 

If above be true, is there limitation of 1GB compressed Dataset as it is in the case of import model?

Thanks in advance.

Regards

Devinder

[Eric_Sergerie]

Played a lot with Power BI and if you find how to do it, let me know. When using live connections, Power BI is pretty much only a report builder application. It loses all the data modelization and import capabilities.