In the previous article I described how to import data to Power BI using MDX query. A new version of eMondrain allows you to load data from Mondrian without any query, using only Power BI designer. eMondrain is a version of Mondrian that is modified to support Excel and some other applications as clients.
As an example, we will load data from the Mondrian sample database Foodmart.
In the Power BI Desktop application we create a new report and select the menu Get data - Analysis Services.
In SQL Server Analysis Services database dialog we fill in the Server field as a connection string to the Mondrian server. Pick the Import radio button and push the Ok button.
To try this example you can use an online eMondrian server with a sample database. The server address is https://ssemenkoff.dev/emondrian/xmla.
Navigator window will appear. There you have to pick up columns that you want to see in your report. While you are choosing columns you will see a data preview on the right side of the window. As you finish push the Load button.
Data will be loaded to our report and available columns will appear on the right side of the application.
This way of loading data from Mondrian OLAP server to Power BI is very simple and doesn’t need any knowledge of a query language.
If you have any questions or suggestions, feel free to contact me at siarhei.semiankou@gmail.com.
Top comments (0)