Forum Discussion

pstaggers's avatar
pstaggers
Advocate II
7 years ago
Solved

Can I connect live to multiple cubes using SQL Server Analysis Service?

I am doing a product warranty analysis from two data cubes.  The first cube has warranty percentages (e.g., 0.25% return rate) and the second cube has warranty issues (e.g., broken hinge).  I can con...
Need Help
  • v-danhe-msft's avatar
    v-danhe-msft
    7 years ago

    Hi pstaggers ,

    Based on my research, I am afraid you could not achieve this feature currently, now the power bi with live connection mode could just get form one AS model.

     

    Regards,

    Daniel He

  • v-danhe-msft's avatar
    v-danhe-msft
    7 years ago

    Hi pstaggers ,

    Could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered to close this topic?

     

    Regards,

    Daniel He

v-danhe-msft's avatar
v-danhe-msft
Microsoft Employee
7 years ago

Hi pstaggers ,

Based on my research, I am afraid you could not achieve this feature currently, now the power bi with live connection mode could just get form one AS model.

 

Regards,

Daniel He

  • Merrin's avatar
    Merrin
    Regular Visitor
    6 years ago

    Hello - is anyone able to advise whether there are any plans to develop this feature?

     

    I too would be very interested in being able to connect a Power BI report to multiple SSAS. I have read through various threads here and on other websites about possible solutions (using Import rather than Live connect, combining all information in one cube source, etc.) but haven't come across a solution that would be suitable in our circumstances.

     

    If there are no plans at all to develop this then I will look at alternative solutions, but was hoping this may be available at some point.

     

    Thanks

    Merrin Rose