From Power BI DAX to Metric View KPIs: How Mercedes-Benz Korea Built “Talk to Your Data” at Scale

Fares Kamal, Sai Yang16 Jun 2026

Problem

Mercedes-Benz Korea keeps 600+ sales and steering KPIs as DAX measures in Power BI and in a central Master KPI catalog. A new question or changed KPI means days or weeks of waiting for BI. A "talk to your data" assistant removes the wait, but an AI that queries tables directly gives plausible numbers that differ from the reports. One wrong answer makes executives stop trusting the tool, and logic locked in Power BI cannot be reused by AI agents.

Example from the article: "how many E-Classes did we sell to a private customer?" has a number that a salesperson and a controller both understand in Power BI. The assistant must return the same number.

Solution in brief

Treat Power BI as the truth and move its KPI logic, via an automated DAX-to-SQL transpiler, into Unity Catalog Metric Views next to the data. The Master KPI catalog serves as the semantic contract. Metric Views are then curated with agent metadata, attached to domain Genie spaces, and tuned with benchmark questions until answers match the reports.

Questions this case answers
  • How to move a large set of BI-tool measures into a governed semantic layer so that a natural-language assistant returns the same numbers as existing reports
  • How to roll out a talk-to-data setup to new markets or units with a repeatable process of benchmark questions and quality gates
  • How to make natural-language KPI answers match the numbers in existing BI reports
  • How to move hundreds of Power BI DAX measures into a governed semantic layer that AI agents can reuse

Tools and methods

  • DAX-to-Metric-View transpiler — converts DAX measures into Metric Views
  • Unity Catalog Metric Views — shared semantic layer for BI and AI
  • Master KPI catalog — KPI definitions and owners, the semantic contract
  • Genie spaces — per-domain natural-language interface
  • Quality gates — 44 traffic-light checks for rolling out to other markets
Continue reading — it's free

Google or a one-time email code. No password.