# Does Power BI have an MCP server?

**Yes — Official.** Power BI maintains an official MCP server.

## Facts

- Verdict: Official (Yes)
- Access: Remote server — Hosted by the vendor — no install, connect over HTTP with OAuth or a token.
- Endpoint: `https://api.fabric.microsoft.com/v1/mcp/powerbi/authoring`
- Package: [`@microsoft/powerbi-modeling-mcp`](https://www.npmjs.com/package/@microsoft/powerbi-modeling-mcp) on npm
- Repository: [microsoft/powerbi-modeling-mcp](https://github.com/microsoft/powerbi-modeling-mcp) — ★ 1.2k, last push 2026-09-29, MIT
- Maintainer: Microsoft
- Category: [Data Platforms](https://mcpyet.com/category/data-platforms/)
- Verified against vendor docs: 2026-09-29
- GitHub data refreshed: 2026-09-29 (re-checked every 6 hours)

## What it does

> The Power BI Modeling MCP Server, brings Power BI semantic modeling capabilities to your AI agents.
> — how [microsoft/powerbi-modeling-mcp](https://github.com/microsoft/powerbi-modeling-mcp) describes itself

## The receipts

- **Vendor-hosted (remote):** `https://api.fabric.microsoft.com/v1/mcp/powerbi/authoring` — a remote server run by Power BI itself, nothing to install. Documented at <https://learn.microsoft.com/en-us/power-bi/developer/mcp/power-bi-authoring-mcp>.
- **Official package:** [`@microsoft/powerbi-modeling-mcp`](https://www.npmjs.com/package/@microsoft/powerbi-modeling-mcp) on npm. The package page carries the exact launch arguments and required credentials.
- **Official repository:** [microsoft/powerbi-modeling-mcp](https://github.com/microsoft/powerbi-modeling-mcp) — ★ 1.2k, pushed 2026-09-29, MIT (active)

## How to connect it

Hosted by the vendor — no install, connect over HTTP with OAuth or a token.

### Claude Code

```sh
claude mcp add --transport http powerbi https://api.fabric.microsoft.com/v1/mcp/powerbi/authoring
```

Add `--scope user` to make it available in every project.

### Claude Desktop

1. Open **Settings → Connectors**
2. Click **Add custom connector**
3. Paste `https://api.fabric.microsoft.com/v1/mcp/powerbi/authoring`
4. Finish the sign-in prompt, then enable it in the chat's tools menu

### Cursor

Add to `.cursor/mcp.json` in your project, or `~/.cursor/mcp.json` for every project:

```json
{
  "mcpServers": {
    "powerbi": {
      "url": "https://api.fabric.microsoft.com/v1/mcp/powerbi/authoring"
    }
  }
}
```

### VS Code

Add to `.vscode/mcp.json`, then pick the server from Copilot's agent-mode tools menu:

```json
{
  "servers": {
    "powerbi": {
      "type": "http",
      "url": "https://api.fabric.microsoft.com/v1/mcp/powerbi/authoring"
    }
  }
}
```

### ChatGPT

1. Enable **Developer mode** under Settings → Apps & Connectors → Advanced
2. Choose **Create** and paste `https://api.fabric.microsoft.com/v1/mcp/powerbi/authoring`
3. Complete sign-in, then enable the connector in a new chat

## How we know

Microsoft documents its Power BI MCP servers on learn.microsoft.com: the Power BI Authoring server is hosted (preview) at api.fabric.microsoft.com/v1/mcp/powerbi/authoring and also runs locally (GA) from microsoft/powerbi-modeling-mcp and npm @microsoft/powerbi-modeling-mcp (Registry com.microsoft/powerbi-modeling-mcp). An older query endpoint (preview) is still documented at /v1/mcp/powerbi.

- GitHub data refreshed 2026-09-29, then every 6 hours.
- Vendor docs verified on 2026-09-29.
- Corrections: hello@mcpyet.com.

## Also in Data Platforms

- [Tableau](https://mcpyet.com/mcp/tableau.md) — Official (Yes)
- [Databricks](https://mcpyet.com/mcp/databricks.md) — Official (Yes)
- [Looker](https://mcpyet.com/mcp/looker.md) — Official (Yes)
- [Metabase](https://mcpyet.com/mcp/metabase.md) — Official (Yes)
- [Amplitude](https://mcpyet.com/mcp/amplitude.md) — Official (Yes)
- [Apache Kafka](https://mcpyet.com/mcp/kafka.md) — Community only (Sort of)

---

Source: https://mcpyet.com/mcp/power-bi/ — data refreshed 2026-09-29