Data Platform Toolkit

Ask your AI assistant where a Power BI number comes from, and get the answer down to the source column.

An MCP (Model Context Protocol) server for Power BI projects saved as PBIP. It reads the files on disk, with no connection to Power BI Desktop, the Power BI service or Microsoft Fabric, and lets an AI assistant:

• analyse and safely edit semantic models in TMDL format (read-only by default);
• find where measures and columns are used in PBIR reports, and which security roles read them;
• trace end-to-end lineage: from the source column of a SQL Server database project, through its medallion layers and Power Query, to the measures and the report visuals.

Asked where the Ratio card of a synthetic test project gets its numbers from, the server follows it back to the files the data warehouse loads (the full example):

flowchart LR
  subgraph L0["source"]
    n0["file:sales/orders/<br/>(Price)"]
    n1["file:sales/orders/<br/>(Qty)"]
    n2["file:targets/*.csv<br/>(Target)"]
  end
  subgraph L1["bronze"]
    n3["raw.orders.Price"]
    n4["raw.orders.Qty"]
  end
  subgraph L2["silver"]
    n5["core.sales.Amount"]
  end
  subgraph L3["gold"]
    n6["mart.sales.Amount"]
    n7["mart.targets.Target"]
  end
  subgraph L4["semantic model"]
    n8["[Ratio]"]
    n9["[Stretch Total]"]
    n10["[Total Sales]"]
    n11["Sales<br/>[Sales Amount]"]
    n12["Targets[Stretch]"]
  end
  subgraph L5["report"]
    n13["Shop / Overview /<br/>'Ratio' (card)"]
  end
  n0 --> n3
  n1 --> n4
  n2 --> n7
  n3 --> n5
  n4 --> n5
  n5 --> n6
  n6 --> n11
  n7 --> n12
  n8 --> n13
  n9 --> n8
  n10 --> n8
  n11 --> n10
  n12 --> n9

Try it

uvx --python 3.13 mcp-data-platform-toolkit --check "C:\path\to\Project.pbip"

--check validates the project and prints a ready-to-paste configuration for your MCP client. Full setup: docs/installation.md.

What you can ask

More requests, with the tools behind each one: docs/tools.md.

How it fits with Microsoft's server

Microsoft's Power BI Modeling MCP Server works inside the semantic model. This server works around it, and answers the questions the model alone can't: which reports and security roles use each field, and where its data comes from.

You don't have to choose. If the official server is installed, this server's optional bridge gives the assistant its modeling tools on the local PBIP folder, from the same connection. Everything else of the official server, such as DAX queries, refresh and cloud operations, stays with it.

Documentation

• Installation and client setup
• Tools reference
• End-to-end lineage and lineage.yaml
• Configuration and options
• Known limitations
• Development: project structure and tests
• Changelog · Contributing · Code of Conduct · Security

Released under the MIT License. Not affiliated with or endorsed by Microsoft. Power BI and Microsoft Fabric are trademarks of Microsoft Corporation.