Power BI – Connect to SSAS Multidimensional models

To connect to SSAS multidimensional models in Power BI Desktop, you can follow these steps:

• Open Power BI Desktop and click on “Get Data” on the Home tab.
• In the “Get Data” window, select “SQL Server Analysis Services” and click on “Connect”.
• In the “SQL Server Analysis Services” window, enter the server name and select the appropriate authentication method. You can also choose to connect to a specific database or cube.
• Click on “Connect” and wait for the connection to be established.
• Once the connection is established, you will see a list of dimensions and measures from the selected cube. You can select the ones you want to use in your Power BI report and click on “Load” to load the data into Power BI.

Note that you may need to have the appropriate permissions to access the SSAS multidimensional models. Also, keep in mind that SSAS multidimensional models are a deprecated feature in SQL Server 2019 and later versions, so you may want to consider using SSAS tabular models instead.

Live connection mode for SSAS multidimensional models is supported by both Power BI Desktop and the Power BI service. Reports that use these models in live mode can be uploaded and published to the Power BI service.