Forum Discussion

SJacobs's avatar
SJacobs
Regular Visitor
10 years ago
Solved

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 com...
  • v-sihou-msft's avatar
    v-sihou-msft
    10 years ago

    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,

v-sihou-msft's avatar
v-sihou-msft
Icon for Microsoft Employee rankMicrosoft Employee
10 years ago

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's avatar
    Anonymous
    Not applicable
    9 years ago

    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