PPower BI Modeling MCP

Tested npm @microsoft/powerbi-modeling-mcp 1.0.1 (MIT; repo microsoft/powerbi-modeling-mcp, 1,276 GitHub stars when checked; Windows and Linux builds). It needs the --start argument; without it, it prints a welcome screen and waits for a key press. With --start, initialize and tools/list worked (22 tools). Every modeling tool needs a connection to a Power BI semantic model (Power BI Desktop, a Fabric workspace or PBIP files), and the server requires accepting Microsoft's EULA (flag, environment variable or the accept_eula tool). We don't accept license agreements or connect accounts, so no tool was called. Core tools not tested.

Transport (tested 2026-11-11): stdio

Score 70/100 · Tools 22 · Token cost approx. 17,921 tokens · Compare · Last tested 2026-11-11 · Version tested 1.0.1 · Package @microsoft/powerbi-modeling-mcp · Repo microsoft/powerbi-modeling-mcp

Summary: Power BI Modeling MCP completed an MCP handshake without credentials and exposed 22 tools.

Evidence summary

Handshake

pass

Tools listed

22

Context cost

approx. 17921 tokens, cl100k estimate (22 tools, measured 2026-11-11, version 1.0.1; an estimate) ranking · add up your servers' context cost

API key

No key to connect (handshake passed)

Tested

2026-11-11

Test results

Local-model readiness

Token cost (estimate): approx. 17921 tokens, cl100k estimate for 22 tools · about 219% of an 8k context. This is an estimate from our testing (counted with cl100k_base).

Small-model friendly (schema heuristic, not a model result): unknown.

What we tested and what we didn't

Methodology: how we test. A high score means it installs and responds, not that giving it access to your data carries no risk.

{
  "name": "@microsoft/powerbi-modeling-mcp",
  "version": "1.0.1",
  "registry": "npm",
  "status": "working",
  "tested": "2026-11-11",
  "tools_count": 22,
  "deprecated": false,
  "archived": false,
  "tests": {
    "install": [
      "pass",
      20,
      "`npm install @microsoft/powerbi-modeling-mcp` (Node 20, Linux) succeeded in 1s."
    ],
    "handshake": [
      "pass",
      30,
      "MCP `initialize` + `tools/list` over stdio succeeded with no credentials; 22 tools listed in 0.9s."
    ],
    "maintenance": [
      "pass",
      25,
      "Repo pushed 4 days before test; 1,276 GitHub stars."
    ],
    "docs": [
      "pass",
      15,
      "README over 3,000 chars; install instructions present; `mcpServers` config example present. Check of the package's own README (README shipped in npm package)."
    ],
    "license": [
      "pass",
      10,
      "MIT (OSI-approved)."
    ]
  }
}

Install

npx -y @microsoft/powerbi-modeling-mcp --startCopy

Pin the version we tested

npx -y @microsoft/powerbi-modeling-mcp@1.0.1 --startCopy

tested 2026-11-11. Newer versions may differ and were not tested by us.

{
  "mcpServers": {
    "power-bi-modeling-mcp": {
      "command": "npx",
      "args": [
        "-y",
        "@microsoft/powerbi-modeling-mcp@1.0.1",
        "--start"
      ]
    }
  }
}

Tools listed

accept_eula, calculation_group_operations, calendar_operations, column_operations, connection_operations, culture_operations, database_operations, dax_query_operations, function_operations, measure_operations, model_operations, named_expression_operations, object_translation_operations, partition_operations, perspective_operations, query_group_operations, relationship_operations, security_role_operations, table_operations, trace_operations, transaction_operations, user_hierarchy_operations

Tool history: captured Nov 11, 2026. All tool history.

Quick config

{
  "mcpServers": {
    "power-bi-modeling-mcp": {
      "command": "npx",
      "args": [
        "-y",
        "@microsoft/powerbi-modeling-mcp",
        "--start"
      ]
    }
  }
}

Add to config Opens the config generator with this server selected.

{
  "mcpServers": {
    "power-bi-modeling-mcp": {
      "command": "npx",
      "args": [
        "-y",
        "@microsoft/powerbi-modeling-mcp",
        "--start"
      ]
    }
  }
}

Related: Best data and analytics MCP servers

FAQ

Is Power BI Modeling MCP deprecated?

No. @microsoft/powerbi-modeling-mcp was not deprecated or archived when we last tested it on 2026-11-11.

What replaces Power BI Modeling MCP?

Nothing; Power BI Modeling MCP is not deprecated as of 2026-11-11.

Does Power BI Modeling MCP need an API key?

No. It completed an MCP handshake with no credentials and listed 22 tools.

Embed the badge

Every tested server gets a free embeddable badge. It shows the current score and test date and expires after 90 days. Testing is free; payment never changes a score.

Copy HTML

Copy Markdown Claim this listing · Report an issue