Super BI MCP

An MCP server that gives AI agents full local Power BI authoring - the semantic model, the report, and Power Query M - by editing .pbix and PBIP/PBIR files directly. 490 tools, backed by ~1,800 automated tests.

Point Claude (or any MCP client) at it and the agent can build a model, write the DAX, lay out the report pages and visuals, transform the Power Query, lint and auto-fix best-practice violations, prove the RLS actually filters, rename a column across the model and every report binding in one atomic call, screenshot the rendered result out of a running Power BI Desktop, evaluate DAX and read table rows out of a closed .pbix with no Fabric, edit a closed .pbit template's model with no Desktop at all, and hand you back a finished .pbix - all on your machine.

Why this instead of the other Power BI MCP servers

The short version: Microsoft's official server stops at the semantic model, and its report story is a separate skill pack that has the LLM hand-write layout JSON. This is one server that authors the whole artifact - model, report, and Power Query - with deterministic, validated tools, treats model and report as one cross-referenced thing (renames propagate, broken bindings are found and fixed, unused fields are provable), and works on the .pbix files you actually have, not just PBIP folders.

Requirements

• Windows x64 (the engine drives the Analysis Services client libraries and, for live-model work, Power BI Desktop)
• Power BI Desktop - needed for live model editing, bulk refresh, bake, and the engine-backed offline .pbix tools; report-layer and file-level tools work without it
• Node.js 16+ to install via npx (below), or the .NET 8 SDK to build from source

Install

One command (recommended) - no .NET SDK needed. Add this to your MCP client's config (Claude Code / Claude Desktop .mcp.json, Cursor, etc.):

{
  "mcpServers": {
    "super-bi": {
      "command": "npx",
      "args": ["-y", "powerbi-pbix-mcp"]
    }
  }
}

The first launch downloads the self-contained engine SuperBiMcp.exe (~109 MB) from the latest release, verifies its SHA-256, and caches it under ~/.powerbi-pbix-mcp/; later launches reuse the cache. Set SUPERBI_MCP_EXE to an existing SuperBiMcp.exe to skip the download.

Prefer a plain binary? Download SuperBiMcp-win-x64.zip from the release, extract, and point your client's command straight at SuperBiMcp.exe.

Build from source (needs the .NET 8 SDK):

git clone https://github.com/cyphonica/powerbi-pbix-mcp
cd powerbi-pbix-mcp
dotnet build src/SuperBiMcp.csproj -c Release

then register the built DLL with "command": "dotnet", "args": ["<absolute path>/src/bin/Release/net8.0/SuperBiMcp.dll"].

Then ask your agent to open a .pbix and get to work. docs/automation-capabilities/GENERATED-TOOL-INDEX.md lists every tool; regenerate it any time with SuperBiMcp capability-map.

CLI modes

The same binary is also a headless factory:

Testing

dotnet test tests/SuperBiMcp.Tests/SuperBiMcp.Tests.csproj -c Release

A handful of live-connector smoke tests skip unless you provide credentials via DAXTEST_* environment variables. Set SUPERBI_TEST_SCRATCH to move test scratch space off your system drive.

Environment variables

License

Source-available under the Functional Source License, FSL-1.1-ALv2 (see LICENSE.md).

Use it freely for anything internal, personal, educational, or for client/consulting work. You may not offer it, or a product substantially built on it, as a competing commercial product or hosted service. Each release automatically becomes Apache 2.0 two years after publication.

This is a curated public mirror of a private development tree; history starts at the first public release and updates land as versioned drops.

Acknowledgements

See NOTICE.md for bundled third-party assets and rule-set attributions.