Claude + Power BI: What the Integration Can (and Can't) Do in 2026
Yes — Microsoft ships an official remote Power BI MCP server, and Claude can connect to it. The endpoint is https://api.fabric.microsoft.com/v1/mcp/powerbi — Fabric-hosted, announced at Ignite in November 2025, and in public preview as of mid-2026. Power BI isn’t in Anthropic’s connectors directory, so you add it as a custom connector, but the server itself is Microsoft’s. Once connected, Claude can read your semantic model’s schema and run DAX queries against your live data in plain English. The catches: a tenant admin has to enable it first, it’s read/query-only (no refreshes, no exports), and — like every Claude integration — it only works inside a conversation you start.
Here’s exactly what the integration does, how to turn it on, where the limits bite, and what to use if you want Power BI work that runs on its own.
What the official Power BI MCP server does
Microsoft ships two official Power BI MCP servers, both public preview:
- The remote server (
api.fabric.microsoft.com/v1/mcp/powerbi) — streamable HTTP with Entra ID OAuth. Four tools: Execute Query (run DAX against a semantic model), Get Semantic Model Schema, Get Report Metadata, and Generate Query (natural language → DAX; this one tool requires a Copilot license or capacity — the other three don’t). Practitioners have confirmed it working with Claude specifically. - The local Modeling server (microsoft/powerbi-modeling-mcp) — a stdio server for authoring: tables, measures, relationships, TMDL/PBIP, DAX validation. This is the developer’s tool; the remote server is the one most people asking “does Claude work with Power BI” actually want.
There’s a second, bigger-picture answer too: since January 2026, Claude models are on by default inside Microsoft 365 Copilot in commercial cloud (opt-in for EU/EFTA/UK), per Microsoft’s own subprocessor doc — including Researcher, Copilot Studio, and Power Platform. So Claude may already be reading your Power BI data inside Copilot without you configuring anything. That’s Microsoft using Claude as a model, though — not your Claude account talking to your reports.
How to set it up
- A Fabric tenant admin enables the preview setting “Users can use the Power BI Model Context Protocol server endpoint” in the admin portal. Without this, nothing works.
- Make sure you have Build permission on the semantic models you want to query.
- In Claude (web or Desktop), go to Settings → Connectors → Add custom connector and point it at
https://api.fabric.microsoft.com/v1/mcp/powerbi. Remote custom connectors require a paid Claude plan. - Sign in with your Entra ID when prompted, then ask Claude something like “what were sales by region last quarter in the Finance model?” — it pulls the schema and writes the DAX itself.
Microsoft’s step-by-step guide covers the details. Note that row-level security is enforced for user sign-in but not for service-principal auth.
The limits that actually matter
- Admin-gated preview. If your tenant admin hasn’t flipped the preview switch, the endpoint refuses you — and preview features can change.
- Query-only. The MCP server reads schemas and runs DAX. It can’t trigger a dataset refresh, export a report page to PDF, or change anything. The write-capable surfaces live in the REST API, not the MCP server.
- No triggers, no monitoring. The server only works inside a conversation you start. There’s no “when the overnight refresh fails, tell me” or “every Monday, send the KPI pack.” Nothing fires on an event.
- Laptop-bound for anything scheduled. The closest thing to “running on its own” is Claude Cowork’s scheduled tasks, which fire on a fixed clock and only “while your computer is awake and the Claude Desktop app is open.”
So Claude is great for “query the model with me right now” — and not built for “watch my refreshes and ship the Monday numbers.”
If you want Power BI work that runs on its own: Carly
The moment you want something to happen around Power BI without you in the chat — the Monday KPI pack in leadership’s inbox, an alert when a refresh fails, a digest when revenue moves — you’ve crossed past what the MCP server is for.
That’s where Carly fits. Carly is an AI executive assistant built to act on triggers. Power BI connects to Carly via your own API credentials (an Entra service principal for the Power BI REST API) — paste them on carlyassistant.com/integrations and it works like any native connection:
- Monday 8am KPI pack — the Export-to-File API renders your exec dashboard to PDF or PPTX and Carly emails it to leadership before the week starts. (Heads-up: API export requires the workspace and its models on Premium/Fabric capacity — Pro-only tenants don’t get it.)
- Refresh-failure watchdog — Carly polls Get Refresh History every 30 minutes and alerts the dataset owner with the error detail the moment a refresh fails. Native failure emails only go to the owner; Carly can tell whoever needs to know. Worth having on Pro too, where you’re capped at 8 refreshes a day and each one counts.
- Anomaly-triggered digest — a scheduled DAX query via Execute Queries compares yesterday’s revenue to the 7-day average; if it moves ±15%, Carly drafts the summary email with the numbers.
- Pre-meeting data pull — an hour before your recurring business review, Carly runs the sales-model query and drops fresh top-line numbers into the meeting brief.
- No-code setup — describe the workflow in plain English; Carly interviews you and builds it.
- Actually sends — drafts and sends email across Gmail and Outlook, updates records, manages tasks.
- Connects to anything — 200+ native integrations, plus any other tool via your own API key.
AI agents start at $35/month, and steps in a workflow that don’t use AI run free and unlimited.
Claude vs Carly
| Claude (Power BI remote MCP) | Carly | |
|---|---|---|
| Query models with DAX | Yes | Yes (Execute Queries API) |
| Read schema & report metadata | Yes | Yes |
| Trigger / monitor refreshes | No (query-only) | Yes |
| Export report pages to PDF/PPTX | No | Yes (on Premium/Fabric capacity) |
| Acts on triggers / schedules | No | Yes |
| Works while laptop is closed | No | Yes (cloud) |
| Sends the numbers by email | No (Gmail draft-only) | Yes (Gmail + Outlook) |
| Pricing | Pro $20 / Max $100–$200 | AI agents from $35/mo |
Claude with the Power BI MCP server is a strong DAX analyst inside a chat. Carly is a teammate that ships the numbers on schedule and flags failures as they happen.
Frequently Asked Questions
Does Claude work with Power BI?
Yes. Microsoft’s official remote Power BI MCP server (api.fabric.microsoft.com/v1/mcp/powerbi) is in public preview, and Claude connects to it as a custom connector. It can read semantic model schemas and run DAX queries. It’s not in Anthropic’s connectors directory, a tenant admin must enable the preview setting first, and it’s read/query-only.
Can Claude refresh a dataset or export a report?
No. The MCP server exposes query and metadata tools only — no refresh, no export. Those live in the Power BI REST API: dataset refresh (capped at 8/day total on Pro; effectively unlimited enhanced refresh on Premium/Fabric) and Export-to-File (Premium/Embedded/Fabric capacity required).
Is Claude already inside Power BI via Copilot?
Sort of. Since January 2026, Claude models run by default in Microsoft 365 Copilot in commercial tenants, including Copilot Studio and Power Platform surfaces. That’s Microsoft using Anthropic models inside its products — separate from connecting your own Claude account to your reports via MCP.
What if I want the Monday numbers emailed without opening a chat?
That’s outside what Claude’s MCP server does — it queries when you ask, it doesn’t run on schedules or react to refresh failures. Carly runs 24/7 in the cloud: scheduled exports, refresh watchdogs, anomaly digests, real email sends. AI agents start at $35/month.
More: Claude + Excel · Claude + Power Automate · Claude + Teams · Claude + SharePoint · Claude connectors · Can Claude send emails
Ready to automate your busywork?
Carly schedules, researches, and briefs you—so you can focus on what matters.
See what people say
"Before Carly, I relied on a Calendly link, but the whole process felt impersonal and not very professional. Carly changed that by handling all the back-and-forth, so I'm no longer stuck in endless email threads trying to line up schedules.
Now Carly reaches out to candidates, shares my real-time availability, lets them pick a slot, then sends a Zoom link and drops it straight into my calendar. She sends reminders to both of us before each call, which has significantly reduced no-shows and last-minute confusion.
On top of scheduling, Carly acts like a full executive assistant, sending me my schedule the night before so I can prepare for each call. It reminds me of the old x.ai assistant, but Carly is noticeably smarter, faster, and better suited to my healthcare recruitment business."
