Connect Claude Code to Microsoft Fabric IQ

Claude Code reaches Microsoft Fabric IQ through one Flowplane address. You add Microsoft Fabric IQ once in Flowplane, add that address to Claude Code, and sign in. Ask questions of your Power BI reports and semantic models: find them, read their structure and run DAX queries. Read-only.

Tools
The app’s own set
Sign-in
Your own account
Approval, by default
Changes wait for you
MCP server
The app’s, passed through
  1. 1

    Add Microsoft Fabric IQ in Flowplane

    In the Flowplane console, add Microsoft Fabric IQ and sign in with Microsoft. There is nothing to fill in.

    Each person signs in with their own Microsoft work or school account, and the assistant sees only the reports, models and data that person can open; row-level and object-level security still apply. Flowplane asks only for the two read permissions Fabric IQ needs. Your organisation may require a Microsoft administrator to approve Flowplane once. Flowplane keeps the login sealed; the assistant never sees it.

    Connect Microsoft Fabric IQ →

  2. 2

    Add Flowplane to Claude Code

    Your address is shown in the Flowplane console; it looks like

    https://mcp.flowplane.eu/<your-label>

    1. Add the server in a terminal with the command below.
    2. Start Claude Code and run /mcp, choose flowplane and sign in to Flowplane in the browser (or run claude mcp login flowplane).
    3. Ask your question; Claude Code calls the tools it needs.
    claude mcp add --transport http flowplane https://mcp.flowplane.eu/<your-label>

    Steps checked against the vendor’s documentation (Anthropic)

  3. 3

    Ask Claude Code

    • “Using the Sales Analytics report, show total sales by region for the last quarter.”
    • “Which semantic models do I have about customers?”
    • “What measures are in the Finance model, and what does Gross Margin mean there?”
    • “Top 10 products by revenue this year, from the Sales model.”
What it can do

What Claude Code can do in Microsoft Fabric IQ

Through Flowplane an AI assistant uses Microsoft Fabric IQ, Microsoft’s read-only MCP server for Power BI. It finds a report or semantic model by name, reads the report’s metadata and the model’s schema, and runs DAX queries against one model at a time, then explains the result. It changes nothing in Power BI, and it does not cover dashboards, paginated reports, Power BI apps, data agents or ontologies.

Microsoft runs Fabric IQ as an official, generally available remote MCP server. Flowplane passes it through as it is, so there is no app registration or client configuration to set up yourself.

FAQ

Questions

Fabric IQ or the Power BI connector?
Fabric IQ, when your organisation has it. Microsoft recommends it for semantic models and reports; the Power BI connector uses Microsoft’s earlier preview endpoint and needs a tenant setting.
Where is Fabric IQ available?
Microsoft offers it to tenants whose home region supports all Fabric workloads, not in Power BI-only regions or sovereign clouds. The reports and models do not need Fabric or Premium capacity. Elsewhere, Flowplane says it is not available yet.
How current are the answers?
As current as the semantic model’s latest successful refresh: the queries read the model, not the source systems behind it.
Does Claude Code see the password or key for Microsoft Fabric IQ?
No. You sign in to Microsoft Fabric IQ through Flowplane, which keeps that sign-in sealed. Claude Code only gets a Flowplane sign-in for you, which you can revoke in the console.
Can Claude Code change things in Microsoft Fabric IQ without asking?
Not by default: reads are allowed and anything that changes something in Microsoft Fabric IQ waits for your approval. Your workspace’s rules can make that stricter or looser.
Your assistant

Other assistants with Microsoft Fabric IQ

Everything about Microsoft Fabric IQ and Flowplane →

Flowplane is not affiliated with or endorsed by Microsoft Fabric IQ’s maker; the name and logo only identify the app. Pricing

Let your AI work with your data. Safely, from today.

Free for yourself, set up in a minute. For your team or company, we’re happy to help you get started.