cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
pstaggers
Advocate I
Advocate I

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 connect either cube individually using Get Data/SQL Server Analysis Services, but I cannot connect to both simultatneously.  One of the cubes is too large to import and merge the data.  Is it possible in PowerBI to connect to two data cubes simultaenously?

2 ACCEPTED SOLUTIONS
v-danhe-msft
Microsoft
Microsoft

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

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

v-danhe-msft
Microsoft
Microsoft

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

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

4 REPLIES 4
gzhou99
New Member

There is no solution to this. The tool just is not capable on multiple SSAS databases. 

v-danhe-msft
Microsoft
Microsoft

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

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
v-danhe-msft
Microsoft
Microsoft

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

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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

Helpful resources

Announcements
November 2022 Update

Check it Out!

Click here to read more about the November 2022 updates!

Microsoft 365 Conference â__ December 6-8, 2022

Microsoft 365 Conference - 06-08 December

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.