Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
pstaggers
Advocate II
Advocate II

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 Employee
Microsoft Employee

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 Employee
Microsoft Employee

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 Employee
Microsoft Employee

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 Employee
Microsoft Employee

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
September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.