Fabric IQ MCP server: query a semantic model from your coding agent

What the Fabric IQ MCP server is and how it works

Clients connect over Streamable HTTP and sign in with delegated OAuth 2.0 through Microsoft Entra ID. Every client needs two Power BI Service permissions: Item.Read.All and Item.Execute.All.

The server applies the caller's existing Fabric permissions. You need no workspace role and no Build permission on the model. Service principals and app-only sign-in are not supported, and there is no administrator impersonation path.

What the demo shows

The 23-second clip makes real calls from a terminal, through a small script named fabric_iq_mcp.py. The runbook runs the same three steps through fabdemo.py.

• 0:00 The window title shows the server endpoint. A comment reads “read-only server, the user's own permissions and RLS.”
• 0:04 tools returns “6 tools, read-only server” and lists ValueSearch, ResolveFabricItem, DiscoverArtifacts, GetReportMetadata, ExecuteQuery, and GetSemanticModelSchema.
• 0:08 discover "Oud RnD" finds one semantic model in the fabcon-gdynia-demo workspace, ranked HighlyRelevant.
• 0:12 dax sends a SUMMARIZECOLUMNS query over formulas[formula_name] with the measure [Avg first choice %].
• 0:17 Six formulas come back. Oud Saffron S-7 leads at 68.0, and Oud Classic is last at 48.0.

The 68.0 matches the expected answer that the recap computes from the synthetic trial data.

Limits and catches

The catch: the two Power BI scopes need no admin consent by default. Any user who can read a model can connect an MCP client of their choice, and the rows land in that client's language model. If that breaks your policy, restrict user consent or require the admin approval workflow.

The server does not answer questions. Learn: “Fabric IQ MCP doesn't expose a natural-language answering tool.” Figure 2 shows who does each step of one question.

How to connect and query the Fabric IQ MCP server

You need the Oud RnD model from the demo script. Runbook D03 also lists the PowerBIMCP tenant setting, turned on by settings on. Per Learn, that setting governs a different server.

python3 fabdemo.py iq-mcp tools
python3 fabdemo.py iq-mcp discover "Oud RnD"
python3 fabdemo.py iq-mcp dax "Oud RnD" 'EVALUATE SUMMARIZECOLUMNS(formulas[formula_name], "Preference %", [Avg first choice %]) ORDER BY [Preference %] DESC'

Expected result: six read-only tools, the model found by name, and the average first-choice share per formula with Oud Saffron S-7 on top at 68. Time and cost: about 3 minutes. Queries use the capacity, which must be Active.

To query from a coding agent, add Learn's configuration for GitHub Copilot CLI to ~/.copilot/mcp-config.json, then run /mcp show FabricIQ and sign in. Learn recommends the Fabric IQ skill from Skills for Fabric alongside it.

{
  "mcpServers": {
    "FabricIQ": {
      "type": "http",
      "url": "https://fabriciq.svc.cloud.microsoft/v1/mcp/fabriciq",
      "tools": ["*"]
    }
  }
}

Do not add an Authorization header. Learn warns that it overrides interactive OAuth and token refresh.

What to do on Monday

On Monday: Pilot Fabric IQ MCP on one workspace with one developer.

For the server that writes, read part 4, the Fabric Core MCP server first.

Key facts at a glance

Checked on Microsoft Learn on November 3, 2026.

Frequently asked questions

Is the Fabric IQ MCP server generally available?

Yes. Microsoft Learn states that Fabric IQ MCP is generally available, as checked on November 3, 2026. It needs a tenant home region that supports all Fabric workloads.

What tools does the Fabric IQ MCP server have?

Six read-only tools: DiscoverArtifacts, ResolveFabricItem, GetReportMetadata, GetSemanticModelSchema, ValueSearch, and ExecuteQuery. There is no natural-language answering tool, so the calling agent writes the DAX and explains the result.

Can a service principal use the Fabric IQ MCP server?

No. Learn states that service-principal and application-only authentication are not supported. The server uses delegated OAuth 2.0 and runs every call under the signed-in user's Power BI permissions.

Does the Power BI MCP tenant setting turn Fabric IQ MCP on or off?

No. The setting Users can use the Power BI Model Context Protocol server endpoints (preview) controls the Power BI Model Authoring MCP experience. Learn states that it does not enable or disable Fabric IQ MCP.

What is the difference between Fabric IQ MCP and Fabric Core MCP?

Fabric IQ MCP is GA and read-only, with six tools for querying Power BI reports and semantic models. Fabric Core MCP manages workspaces, items, roles, and OneLake settings. Its Learn tools reference listed 43 tools on November 3, 2026, and 25 of them write.

Sources

Microsoft Learn, checked on November 3, 2026, then the recap materials.

• Learn: Get started with the Fabric IQ MCP server
• Learn: What are Fabric MCP Servers?
• Learn: Use Copilot with semantic models
• Learn: Skills for Fabric overview
• Runbook D03: Fabric IQ MCP server