Connect Claude to Power BI
Claude reaches Power BI through one Flowplane address. You add Power BI once in Flowplane, add that address to Claude, 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.
- 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
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.
- 2
Add Flowplane to Claude
Your address is shown in the Flowplane console; it looks like
https://mcp.flowplane.eu/<your-label>- In Claude, open Customize › Connectors, choose + Add, then Add custom connector.
- Give it a name, paste your Flowplane address
https://mcp.flowplane.eu/<your-label>and choose Continue. - Keep sign-in on Sign in now, choose Add, then sign in to Flowplane in the window that opens and allow Claude.
- In a chat, open + › Connectors and turn Flowplane on.
Steps checked against the vendor’s documentation (Anthropic)
- 3
Ask Claude
- “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 Claude 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.
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 Claude see the password or key for Power BI?
- No. You sign in to Power BI through Flowplane, which keeps that sign-in sealed. Claude only gets a Flowplane sign-in for you, which you can revoke in the console.
- Can Claude 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.
- Connect Claude Code to Power BI→
- Connect ChatGPT to Power BI→
- Connect Cursor to Power BI→
- Connect Codex to Power BI→
- Connect GitHub Copilot to Power BI→
- Connect Mistral Le Chat to Power BI→
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.