Open-source semantic layer

One semantic model for Excel, Power BI and AI agents.

Define your business model once on ClickHouse or any SQL database, and query it natively from Excel (MDX), Power BI (DAX), and AI agents (MCP).

Try the live demo Install Community Pricing

Open-source core (EPL-1.0) · Built on Mondrian OLAP · XMLA-compatible · 28K+ Docker pulls

Three ways to use your semantic model

The same cubes, measures, and hierarchies, in the tools your people already use.

table_chart

Excel

Connect PivotTables to eMondrian through the built-in Analysis Services connection. Slice, drill down, and build reports on live data.

Protocol: XMLA / MDX

lock_openFree · Community
bar_chart

Power BI

Power BI connects to eMondrian as a semantic model (live connection). Build reports on top of governed measures without importing data.

Protocol: XMLA / DAX

extensionDAX module
smart_toy

AI agents

Give AI agents access to your business model instead of raw tables: they see cubes, measures, and dimensions, and query them with consistent definitions.

Protocol: MCP

extensionMCP module

Also available: Writeback module. Enter and update data (plans, budgets, and forecasts) from Excel back into the model.

Why a semantic layer

hub

Define once, use everywhere

Revenue, margin, and active customers are defined once in the model, not re-implemented in every report, spreadsheet, and AI prompt.

database

Keep your data where it is

eMondrian queries your database directly. No extra copy of the data, no proprietary storage format.

cable

Native protocols, not adapters

Excel and Power BI talk to eMondrian the same way they talk to Analysis Services: via XMLA. No custom drivers on user machines.

code

Open core

The engine is open source and builds on Mondrian, a proven OLAP engine used in production for many years.

From first look to production

1

Try the demo

Connect Excel, Power BI, or an AI agent to our public demo server. No installation, takes about two minutes.

Open the demo guide
2

Evaluate on your data

Install Community with Docker, connect your database, and run a proof of concept. Free evaluation key for DAX and MCP.

Get started
3

Go to production

Buy a commercial license for the modules you use, or Enterprise if you need our support with your workloads.

See pricing

Built by a small team

eMondrian is developed by BIS, a small team specialised in open-source BI. We would rather tell you upfront what we can and cannot promise:

  • check_circle Support during business hours (Monday to Friday, UTC+4). No 24/7.
  • check_circle DAX compatibility is growing but not complete. Check your own reports during the evaluation.
  • check_circle Microsoft does not officially support third-party servers via the Analysis Services connector. We test each Power BI release.
Read what to expect