---
title: "Power BI MCP Server: Claude and ChatGPT Setup | SourceMedium"
description: Fabric IQ MCP, generally available, runs read-only DAX against Power BI semantic models; a preview Authoring server edits models, hosted or local.
url: "https://sourcemedium.com/mcp-directory/power-bi/"
type: static
generatedAt: "2026-09-29T05:41:53.000Z"
---

[MCP Directory](https://sourcemedium.com/mcp-directory/) BI and reporting Official
# Power BI MCP server

Remote endpoint fabriciq.svc.cloud.microsoft/v1/mcp/fabriciq. Checked September 2026.

Fabric IQ MCP, Microsoft's hosted server, finds a company's Power BI reports and semantic models, reads their tables and measures, and runs read-only DAX queries as the signed-in user with row-level security applied. A preview Authoring server, hosted or run locally, edits the models themselves: tables, columns, measures, relationships, and security roles.

## Power BI MCP options

Every fact in a row comes from the publisher's own documentation.

| Option | Audience | Reads or changes | Sign-in | Setup |
| --- | --- | --- | --- | --- |
| Fabric IQ MCP `https://fabriciq.svc.cloud.microsoft/v1/mcp/fabriciq` Microsoft | Merchants | Microsoft-hosted server that finds Power BI reports and semantic models, reads their metadata, searches stored values, and runs DAX queries as the signed-in user, with row- and object-level security applied; no dashboards, paginated reports, or apps. Read only | OAuth sign-in | [Setup guide →](https://learn.microsoft.com/en-us/fabric/iq/connectors/fabric-iq-mcp) |
| Power BI Consumption MCP server `https://api.fabric.microsoft.com/v1/mcp/powerbi` Microsoft | Merchants | The earlier remote query endpoint: reads a semantic model's schema and a report's metadata, generates DAX with Copilot, and runs it; Microsoft directs new consumption work to Fabric IQ MCP. Read only | OAuth sign-in | [Setup guide →](https://learn.microsoft.com/en-us/power-bi/developer/mcp/remote-mcp-server-get-started) |
| Power BI Authoring MCP server, hosted `https://api.fabric.microsoft.com/v1/mcp/powerbi/authoring` Microsoft | Developers | Microsoft-hosted endpoint that creates, changes, and deletes tables, columns, measures, relationships, and security roles in semantic models in Fabric workspaces, and runs DAX to validate them. Can write | OAuth sign-in | [Setup guide →](https://learn.microsoft.com/en-us/power-bi/developer/mcp/power-bi-authoring-mcp#set-up-the-hosted-server) |
| Power BI Authoring MCP server, local Microsoft [Registered as com.microsoft/powerbi-modeling-mcp](https://registry.modelcontextprotocol.io/?q=com.microsoft%2Fpowerbi-modeling-mcp) | Developers | The same authoring tools run on your machine over stdio (VS Code extension or @microsoft/powerbi-modeling-mcp), adding models open in Power BI Desktop, Power BI Project and TMDL files on disk, transactions, traces, and service principal sign-in. Can write | OAuth sign-in | [Setup guide →](https://learn.microsoft.com/en-us/power-bi/developer/mcp/power-bi-authoring-mcp#set-up-the-local-server) |

## Connect Power BI to your assistant

Each card lists the servers whose setup guide covers that assistant.

### Connect Power BI to ChatGPT or Claude

- [Power BI Consumption MCP server →](https://learn.microsoft.com/en-us/power-bi/developer/mcp/remote-mcp-server-get-started)
- [Power BI Authoring MCP server, hosted →](https://learn.microsoft.com/en-us/power-bi/developer/mcp/power-bi-authoring-mcp#set-up-the-hosted-server)

### Connect Power BI to VS Code

- [Power BI Consumption MCP server →](https://learn.microsoft.com/en-us/power-bi/developer/mcp/remote-mcp-server-get-started)
.vscode/mcp.json

```
{"servers":{"power-bi":{"type":"http","url":"https://api.fabric.microsoft.com/v1/mcp/powerbi"}}}
```
- [Power BI Authoring MCP server, hosted →](https://learn.microsoft.com/en-us/power-bi/developer/mcp/power-bi-authoring-mcp#set-up-the-hosted-server)
.vscode/mcp.json

```
{"servers":{"power-bi":{"type":"http","url":"https://api.fabric.microsoft.com/v1/mcp/powerbi/authoring"}}}
```
- [Power BI Authoring MCP server, local →](https://learn.microsoft.com/en-us/power-bi/developer/mcp/power-bi-authoring-mcp#set-up-the-local-server)

Power BI's setup guides also name GitHub Copilot CLI.

## Tools each server exposes

Listed as each publisher documents them. A write tool can change something in the account.

### Fabric IQ MCP 6 tools: 6 read, 0 write

Read

- `DiscoverArtifacts`
- `ResolveFabricItem`
- `GetReportMetadata`
- `GetSemanticModelSchema`
- `ValueSearch`
- `ExecuteQuery`

### Power BI Authoring MCP server, local 23 tools: 3 read, 20 write

Read

- `connection_operations`
- `dax_query_operations`
- `trace_operations`

Write

- `database_operations`
- `transaction_operations`
- `model_operations`
- `table_operations`
- `column_operations`
- `measure_operations`
- `relationship_operations`
- `partition_operations`
- `user_hierarchy_operations`
- `calculation_group_operations`
- `security_role_operations`
- `perspective_operations`
- `named_expression_operations`
- `function_operations`
- `culture_operations`
- `object_translation_operations`
- `calendar_operations`
- `query_group_operations`
- `data_source_operations`
- `accept_eula`

## Other ways to reach Power BI data

- [Power BI REST API: Execute Queries →](https://learn.microsoft.com/en-us/rest/api/power-bi/datasets/execute-queries)
- [Copilot for Power BI →](https://learn.microsoft.com/en-us/power-bi/create-reports/copilot-introduction)

## One MCP server per tool still can't answer a cross-channel question.

Each server brings its own sign-in, its own definition of revenue, and data your assistant can't join to the rest.

SourceMedium connects 63 commerce and marketing sources, keeps one set of maintained definitions, and gives ChatGPT, Claude, and other assistants a single connection to all of it. Power BI is not a SourceMedium source today.
## More in BI and reporting

- [Tableau MCP server →](https://sourcemedium.com/mcp-directory/tableau/)
- [Google Sheets MCP server →](https://sourcemedium.com/mcp-directory/google-sheets/)
- [Looker MCP server →](https://sourcemedium.com/mcp-directory/looker/)