Connect to a live semantic model in two minutes.

1. In Excel: Data → Get Data → From Database → From Analysis Services.
2. Server name: https://demo.emondrian.com/xmla
3. Select a cube (for example, Sales from FoodMart) and click Finish.
4. Build a PivotTable: drag Unit Sales to Values and Product Family to Rows.

Or try MDX directly in the Web OLAP client:

SELECT [Measures].[Unit Sales] ON COLUMNS,
       [Product].[Product Family].Members ON ROWS
FROM [Sales]

1. In Power BI Desktop: Get data → Analysis Services.
2. Server: https://demo.emondrian.com/xmla
3. Choose Connect live and click OK.
4. Select a cube and start building visuals.

Want to see what Power BI sends? Open Performance Analyzer in Power BI Desktop and copy the DAX query of any visual.

Power BI connects to eMondrian through the Analysis Services connector. Microsoft does not officially support this for third-party servers. See what to expect.

MCP is not yet available on the public demo. You can run it locally: install Community, activate an evaluation key, and connect your MCP client to http://localhost/emondrian/mcp/sse. See the Quickstart.

claude mcp add --transport sse emondrian http://localhost/emondrian/mcp/sse

Example prompts:

• chat “Which cubes and measures are available?”
• chat “Show unit sales by product family for 1997 and explain the biggest change.”
• chat “Which store had the highest profit margin?”