Start free

Connect ChatGPT to Microsoft Fabric IQ

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

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
  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 ChatGPT

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

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

    1. In ChatGPT on the web, open Plugins, choose + and Add custom MCP server.
    2. Give it a name and, under Connection, paste https://mcp.flowplane.eu/<your-label>. Set authentication to OAuth.
    3. Tick I understand and want to continue and choose Create as a plugin.
    4. Install it, sign in to Flowplane and allow ChatGPT. In a chat, type @ and pick it.

    Steps checked against the vendor’s documentation (OpenAI)

  3. 3

    Ask ChatGPT

    • “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 ChatGPT 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 ChatGPT 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. ChatGPT only gets a Flowplane sign-in for you, which you can revoke in the console.
Can ChatGPT 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.

Start free →Book a call