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, beta), and AI agents (MCP).

Try the live demo Install Community Pricing

License

EPL-1.0 open-source core

Engine

Built on Mondrian OLAP

Protocol

XMLA-compatible

Adoption

28K+ Docker pulls

Clients

Three ways to use your semantic model

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

Excel

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

XMLA · MDX Free · Community

Power BI

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

XMLA · DAX DAX module · beta

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.

MCP MCP module

Why

Why a semantic layer

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.

Keep your data where it is

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

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.

Open core

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

Adoption

From first look to production

  1. 01

    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. 02

    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. 03

    Go to production

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

    See pricing

The team

Built by a small team

eMondrian is developed by BIS, a small team led by its founder Sergei Semenkov, who has 25 years of experience in OLAP. We would rather tell you upfront what we can and cannot promise.

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