How to Connect to an Analysis Services Database in Power BI


In this article, we will learn how to connect an Analysis Services database in Power BI. This article is oriented toward people who are learning SSAS and want to create some reports using Power BI.

Multidimensional projects

Analysis Services is an OLAP technology used for decision support that can be complemented with Power BI. In this example, we will show how to connect Power BI with an Analysis Services Multidimensional project.

Requirements to connect an Analysis Services database in Power BI

First of all, you need to have the AdventureworksDW database installed. In this example, we are using the AdventureworksDW2019