Start free

Connect ChatGPT to Power BI

ChatGPT reaches Power BI through one Flowplane address. You add Power BI once in Flowplane, add that address to ChatGPT, and sign in. Ask questions of your Power BI semantic models: read a model’s schema or a report’s metadata and run DAX queries. Read-only, preview.

Connect Power BI →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 Power BI in Flowplane

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

    Each person signs in with their own Microsoft work or school account; queries run as that person, with row-level security applied, and need Build permission on the model. Flowplane asks only for read permissions. A Power BI administrator has to turn on the tenant setting “Users can use the Power BI Model Context Protocol server endpoint (preview)”, and a Microsoft administrator may have to approve Flowplane once. Flowplane keeps the login sealed; the assistant never sees it.

    Connect Power BI →

  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

    • “What tables are in semantic model 1a2b3c4d-…?”
    • “Show the top 10 products by sales in the Sales model.”
    • “Which pages and visuals does the Monthly Finance report have, and which measures do they use?”
    • “Compare revenue per month this year with last year.”
What it can do

What ChatGPT can do in Power BI

Through Flowplane an AI assistant uses Microsoft’s remote Power BI MCP server, in preview, to answer questions from your semantic models. It reads a model’s tables, columns, measures and relationships or a report’s pages and visuals, runs DAX queries, and with Copilot can have Power BI write the DAX for it. It only reads. Where your organisation has Microsoft Fabric IQ, Microsoft recommends that instead.

Microsoft runs an official remote MCP server for Power BI, currently in preview. Flowplane passes it through as it is, so there is nothing to install or configure in a client.

FAQ

Questions

Power BI or Microsoft Fabric IQ?
Microsoft recommends Fabric IQ for semantic models and reports, and it is generally available. Use the Power BI connector where Fabric IQ is not available to you: it is Microsoft’s earlier preview endpoint and may change.
What does my administrator have to switch on?
In the Power BI admin portal, the tenant setting “Users can use the Power BI Model Context Protocol server endpoint (preview)” for the people who should use it. Letting Power BI generate the DAX also needs a Copilot license; without it the assistant writes the query itself.
How does the assistant know which model to use?
Microsoft’s server works with a semantic model’s ID. You find it in the model’s address in the Power BI service, after /datasets/, and give it to the assistant.
Does ChatGPT see the password or key for Power BI?
No. You sign in to Power BI 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 Power BI without asking?
Not by default: reads are allowed and anything that changes something in Power BI waits for your approval. Your workspace’s rules can make that stricter or looser.
Your assistant

Other assistants with Power BI

Everything about Power BI and Flowplane →

Flowplane is not affiliated with or endorsed by Power BI’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