cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
pstaggers Occasional Visitor
Occasional Visitor

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?

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

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

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.
2 REPLIES 2
Community Support Team
Community Support Team

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

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.
Community Support Team
Community Support Team

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

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.