multiple SSAS cubes

[powerbiexpert22]

is it possible to connect with multiple SSAS cubes in power bi? 

[v-achippa]

Hi @powerbiexpert22,

Thank you for reaching out to Microsoft Fabric Community.

Thank you @bhanu_gautam and @BhavinVyas3003 for the prompt response.

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by the super user's resolved your issue? or let us know if you need any further assistance.
If our super user's response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.

Thanks and regards,

Anjan Kumar Chippa

[BhavinVyas3003]

Hi,

Yes, you can connect multiple SSAS cubes in Power BI, but it depends on the connection mode:

Import mode: You can connect to multiple cubes and build relationships as needed.

Live connection (Multidimensional): Only one cube per report is allowed.

Composite model (Tabular, 2021+ compatibility): You can mix live SSAS and imported data.

Thanks,

Bhavin

[bhanu_gautam · Accepted solution]

@powerbiexpert22 

Yes, it is possible to connect with multiple SSAS (SQL Server Analysis Services) cubes in Power BI. You can achieve this by creating multiple data sources within your Power BI report, each connecting to a different SSAS cube. Here are the steps to do this:

Open Power BI Desktop.
Click on "Get Data" and select "SQL Server Analysis Services database".
Enter the server name and select the appropriate connection mode (Import or Live Connection).
Select the cube you want to connect to and load the data.
Repeat the process for each additional SSAS cube you want to connect to.