Skip to main content
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.

Ways to reach Power BI data from an assistant
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 (opens in a new tab)
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 (opens in a new tab)
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 (opens in a new tab)
Power BI Authoring MCP server, local Microsoft Registered as com.microsoft/powerbi-modeling-mcp (opens in a new tab) 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 (opens in a new tab)

Connect Power BI to your assistant

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

Connect Power BI to ChatGPT or Claude

Connect Power BI to VS Code

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

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.

Book a walkthroughSee how it works
See supported sources

More in BI and reporting