Update 2026: Power BI can now connect to eMondrian live — no MDX import needed. eMondrian answers the DAX queries Power BI sends, and AI agents can use the same model over MCP. See The new eMondrian: Power BI and AI agents on your own semantic model.
However it’s impossible to explore Mondrian cubes in Power BI Desktop through live connection, there is a way how you can load data from Mondrian by queries.
Let’s load data from the Mondrian sample database Foodmart and create a simple interactive report. This example is using the eMondrain version of Mondrian that is modified to support Excel and some other applications as clients.
First we have to design a MDX query. Following query gets sales amount data with dates and store information.
SELECT
[Measures].[Store Sales] on COLUMNS,
CrossJoin( [Time].[Month].Members, [Store].[Store Name].Members ) on ROWS
FROM [Sales]
Mondrian server can return data in two formats. First format is CellSet data format which is convenient in case of using client controls like Pivot Table.
The second format is tabular format. It’s a simple table and is convenient when you are designing a report with tables and charts. This format is used by Power Bi when it loads data from Mondrian.
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. Fill in database name in field Database. Database is a required field and is case sensitive (in our case it's FoodMart). Pick the Import radio button. In the MDX or DAX query (optional) field copy our MDX query 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.
Preview window will appear where you can see part of the query result data in tabular format. Click the Load button.
Go to the Data tab, rename columns and change Sales column data type from Text to Decimal number.
Let’s return to the Report tab and add some visualizations. In this example we use Slicer, Pie chart and Table controls.
To refresh your report and load newly added data you can always use the Refresh button.
As you see, you can add to your Power BI Desktop reports new ones which use data from the Mondrian OLAP server.
If you have any questions or suggestions, feel free to contact me at siarhei.semiankou@gmail.com.
Top comments (6)
Is it posible to connect mondrian with Power BI if you check "import" without specifying a MDX query or if you check Connect live?
Hi Pablo, a late but better answer to your question from 2021: yes, "Connect live" works now.
eMondrian now answers the DAX queries Power BI sends, so you can use Get data → Analysis Services → Connect live — no MDX query, no import. Your measures stay in the eMondrian schema and the data stays in your database (ClickHouse, PostgreSQL or another JDBC source).
You can try it without installing anything: connect Power BI Desktop to
https://demo.emondrian.com/xmla.Details: The new eMondrian: Power BI and AI agents on your own semantic model
DAX support is still in beta, so if a visual doesn't work for you, I'd be glad to hear about it.
Hi Pablo. "Connect live" option does not work for a Mondrian server.
Hi Sergei, and the "Import" option without specifying a MDX query?
No. You have to write MDX query.
Now you can. Have a look at this dev.to/sergeisemenkov/a-simple-way...