Start free
Files, notes and calendars

Microsoft Fabric IQ MCP server

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.

Connect Microsoft Fabric IQ →Set up your assistant
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
What it can do

What your assistant can do in Microsoft Fabric IQ

Flowplane passes Microsoft Fabric IQ’s own MCP server through, so the tools are the ones Microsoft Fabric IQ offers when you connect. By default reads are allowed and anything that changes something waits for the person’s approval; your workspace’s rules decide.

Reads allowed

Looking things up runs straight away, within what the account you connected may see.

Changes asks first

Creating, changing or deleting waits for your approval in the browser, unless your workspace’s rules say otherwise.

How it connects

Sign-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.

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

MCP

Microsoft Fabric IQ and MCP

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.

Try it

Things to ask

  • “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.”
Your assistant

Connect your assistant to Microsoft Fabric IQ

One Flowplane address works in every assistant below, with the same rules and the same log. Step-by-step setup for each:

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.
Which AI assistants can use Microsoft Fabric IQ through Flowplane?
Claude, Claude Code, ChatGPT, Cursor, Codex, GitHub Copilot and Mistral Le Chat, and any other client that supports remote MCP servers with sign-in. They all reach Microsoft Fabric IQ through the same Flowplane address.
What does it cost?
Free for one person, with up to three apps and five assistants. Personal Pro is €9 a month including VAT; companies start at €99 a month for ten active users. Prices are indicative; see the pricing page.

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.

Start free →Book a call