cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
SJacobs Visitor
Visitor

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

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?

1 ACCEPTED SOLUTION

Accepted Solutions
Moderator v-sihou-msft
Moderator

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

@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,

View solution in original post

4 REPLIES 4
Eric_Sergerie Regular Visitor
Regular Visitor

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

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.

Moderator v-sihou-msft
Moderator

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

@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,

View solution in original post

mahimabedi
Advisor

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

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

Anonymous
Not applicable

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

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

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

January 2020 Community Highlights

January 2020 Community Highlights

Make sure you didn't miss any of the things that happened in the community in January!

Top Solution Authors
Top Kudoed Authors