Start free
Files, notes and calendars

Power BI MCP server

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.

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
What it can do

What your assistant can do in Power BI

Flowplane passes Power BI’s own MCP server through, so the tools are the ones Power BI 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; 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.

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

MCP

Power BI and MCP

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.

Try it

Things to ask

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

Connect your assistant to Power BI

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

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.
Which AI assistants can use Power BI 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 Power BI 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 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