Power BI MCP connector
Connect Power BI to Elaichi and Claude, ChatGPT, Cursor and Microsoft Copilot can find workspaces, reports, dashboards and users, create workspaces and clone dashboard tiles, each person signed in as themselves, every action logged.
- Connects over OAuth
- Free 14-day trial
- No credit card
Which workspace holds the monthly revenue report?
Working in Power BI with Elaichi
-
List all Power BI users
-
List all Power BI workspaces
-
Get single Power BI workspace by ID
How to connect Power BI to Claude, ChatGPT, Cursor or Microsoft Copilot
Step by step, for each AI app
Power BI MCP connector for Claude
-
1
Open Customize, then Connectors.
-
2
Press Add.
-
3
Name it, paste the MCP server URL, then Continue.
https://api.elaichi.ai/mcp -
4
Sign in and approve.
On Team and Enterprise, an Owner adds it once. Everyone else turns it on for themselves.
Power BI MCP connector for Claude Code
-
1
In a terminal, run
claude mcp addwith the endpoint.https://api.elaichi.ai/mcp -
2
Start Claude Code and run
/mcp. -
3
Pick elaichi, then sign in and approve in the browser.
Terminal
$ claude mcp add --transport http elaichi --scope user https://api.elaichi.ai/mcp
Use --scope project instead to share it with the repository through .mcp.json.
Power BI MCP connector for ChatGPT
-
1
Open Plugins, then press the + button.
-
2
Name it and paste the endpoint into Server URL.
https://api.elaichi.ai/mcp -
3
Leave Authentication on OAuth, then tick the risk acknowledgement.
-
4
Press Create, then sign in and approve.
Works on the web. The plugin directory lives at chatgpt.com/plugins.
Power BI MCP connector for Cursor
-
1
Open
~/.cursor/mcp.json. -
2
Add the endpoint under
mcpServers.https://api.elaichi.ai/mcp -
3
Reload Cursor, then sign in and approve.
~/.cursor/mcp.json
{
"mcpServers": {
"elaichi": {
"url": "https://api.elaichi.ai/mcp"
}
}
}
Set up per machine, so repeat it on each computer you work from.
Power BI MCP connector for Microsoft Copilot
-
1
In Copilot Studio, open your agent, then Tools, Add a tool, New tool and Model Context Protocol.
-
2
Paste the endpoint into Server URL, choose OAuth 2.0, then Dynamic discovery, and press Create.
https://api.elaichi.ai/mcp -
3
Create a new connection, sign in and approve, then press Add to agent.
-
4
Under Channels, open Teams and Microsoft Copilot and make the agent available in Microsoft Copilot.
- Server URL
- https://api.elaichi.ai/mcp
- Authentication
- OAuth 2.0
- Type
- Dynamic discovery
Microsoft Copilot was called Microsoft 365 Copilot. Keep the tool on end-user credentials, so each person signs in as themselves.
Connect Power BI to any MCP client
-
1
Add the endpoint as a remote MCP server.
https://api.elaichi.ai/mcp -
2
Sign in and approve.
{
"mcpServers": {
"elaichi": {
"url": "https://api.elaichi.ai/mcp"
}
}
}
The Elaichi Agent already has these tools, with nothing to set up.
What teams do with Power BI through Elaichi
Ask in plain English. Each person’s AI can do only what they’re allowed to, and every action it takes in Power BI is logged.
-
Analytics
Set up a workspace for a new project
Ask for a new Power BI workspace with the right name and it is created on the spot, ready for the first report to land in it.
-
Finance
Find the month-end report without hunting
Ask which app holds the P&L report or the cash dashboard and get the answer, with the workspace it lives in, instead of clicking through the portal.
-
Operations
Copy tiles onto a new dashboard
Clone the tiles from last quarter's dashboard onto a fresh one for this quarter so nobody rebuilds visuals by hand.
-
IT
Clean up users who no longer need access
List every Power BI user, spot the ones who changed roles or left, and update or remove them in one pass.
-
Data engineering
Check who can trigger refreshes
Pull the list of refresh permissions to see exactly who is allowed to kick off a dataset refresh before you hand a schedule to someone new.
-
IT
Keep capacity workloads in balance
Review the workloads on each Power BI capacity and adjust the settings when one workspace is crowding out the others.
Try asking
- “Which workspace holds the monthly revenue report?”
- “Create a workspace called Q3 Planning for the finance team”
- “List everyone who can trigger a dataset refresh”
What connecting Power BI gets you
6 screens from Elaichi, each doing one job for your Power BI account.
Ask Elaichi to work across your apps.
Which workspace holds the monthly revenue report?
Create a workspace called Q3 Planning for the finance team
List everyone who can trigger a dataset refresh
Also runs in Claude, ChatGPT, Cursor or Microsoft Copilot
The agent
Ask about Power BI workspaces in plain words.
Find reports, dashboards and users across workspaces by asking, with no portal clicking.
Copy the endpoint
AI apps
One endpoint brings Power BI to every client.
Claude, ChatGPT and Cursor connect over OAuth, no SDK and no shared API key.
Tool catalog
174 Power BI tools, no custom code needed.
Workspaces, reports, dashboards, tiles, users and capacities, covered the day you connect.
Toolboxes
Each team gets its own Power BI toolbox.
Analytics builds workspaces, IT manages users, Finance only finds reports.
Shared connections
Share one Power BI connection, keep the credential.
Teammates work through the connection you set up without ever seeing a secret.
Audit log
Every Power BI action lands in the log.
When, who, what happened and which workspace or dashboard, answered in seconds.
From answering questions to doing the work
A trigger starts the work, inside the same permissions and the same audit log as everything else. Workflows, collections and live dashboards come with the Black plan.
Power BI digest
Run 418 · started 2 minutes ago · on behalf of Emily Carter
-
✓
Schedule
Every weekday at 8:00 AM
0.2s -
✓
Fetch workspaces
Power BI
1.4s -
✓
Group by owner
Transform
0.1s -
✓
Draft the digest
Agent step
Ran with 4 tools, returned a structured summary
6.2s -
Approve the digest
Needs approval
Assigned to Jake Morgan
Approve Deny -
Post the digest
Power BI
Queued
Workflows
A schedule starts Power BI work, you approve.
New workspaces are fetched, grouped and drafted into a digest you approve before it posts back.
Power BI health
Refreshed 4 minutes ago · every 15 minutes · from the workspaces collection
Workspaces
1,284 ↓ 12%
Reports
96 ↓ 8%
Needs attention
3 ↑ 2
Updated this week
412 ↑ 9%
Workspaces created
Last 14 days
By team
Share of activity
Analytics 34%
Finance 27%
IT admin 21%
Sales ops 18%
Collections and dashboards
Power BI health numbers, refreshed on schedule.
Workspaces created over 14 days, split by team, with no model in the math.
For IT and engineering
Elaichi vs Zapier MCP vs Composio for Power BI
All three can connect Power BI to an AI assistant, and all three have admin controls. They differ in where access lives and how you pay.
| What to check | Elaichi | Zapier MCP | Composio |
|---|---|---|---|
| Where the AI connects |
One address for the whole organization.
https://api.elaichi.ai/mcp
|
A server per member, created at sign-in. | An MCP endpoint per team, or an SDK. |
| Control over Power BI tools | Allow or restrict single Power BI tools, per role or user. | App and action restrictions on the account. | Role permissions, down to the action. |
| Record of calls | One audit entry per Power BI call. | A History tab of tool calls. | A log of every tool call. |
| Single sign-on | SAML or OIDC, plus SCIM, on Gold. | SAML on Enterprise. | SAML and OIDC on Enterprise. |
| Price | Free for one person; $15 per user per month on Gold. | 2 tasks per successful call. | Billed per tool call. |
Sources: Zapier MCP docs, security, usage; Composio docs, gateway, enterprise, pricing. Checked September 2026.
Longer take: Zapier MCP alternative and when you don't need an MCP gateway.
Power BI tools for your AI agents
174 tools are ready to call through Elaichi's MCP endpoint the moment you connect Power BI, governed by the same roles, restrictions, and audit log as everything else in Elaichi.
No tools match your search.
Questions, answered
How do I connect Power BI to Claude?
Connect Power BI in Elaichi, where you sign in to Power BI with your normal Microsoft account over OAuth, and there is no OAuth application to register and no client ID or secret to generate. Then open Claude, go to Customize, then Connectors, then Add, and paste https://api.elaichi.ai/mcp. Claude asks you to sign in to Elaichi and Power BI is ready to use.
Does Power BI work with ChatGPT and Cursor as well as Claude?
Yes. Once Power BI is connected in Elaichi, the same endpoint, https://api.elaichi.ai/mcp, works in Claude, ChatGPT, Cursor, Microsoft Copilot, any MCP client and the Elaichi Agent. You connect Power BI once and every client you sign in to sees it.
What can an AI agent actually do with my Power BI data?
It can list your Power BI workspaces, reports, dashboards and the tiles on them, find which app a report belongs to, create or update a workspace, clone tiles onto another dashboard, and manage users, refresh permissions and capacity workloads. In practice that means asking where the revenue report lives, setting up a workspace for a new project, or checking who can trigger a refresh. Short concrete asks work better than long sentences.
Does connecting Power BI give the AI access to every workspace?
No. Access follows the person who signed in, so the agent only sees the Power BI workspaces, reports and dashboards that person can already open, and it respects the same permissions Power BI applies to them. Elaichi can narrow that access further with roles and restrictions, and it can never widen it.
Can I stop an agent from deleting or changing things in Power BI?
Yes. Restrictions in Elaichi work per action, so you can restrict deleting a Power BI workspace or removing a user for a role or for one person while leaving listing and finding untouched. A restricted tool still appears in Elaichi's tool search, flagged as restricted, but no client can run it, whatever the prompt says.
What happens to a Power BI connection when someone leaves?
Offboarding that person in Elaichi ends their access to Power BI through every client at once. A shared Power BI connection keeps working for everyone else on the team. If you want the connection gone entirely, disconnecting Power BI once in Elaichi removes it from Claude, ChatGPT, Cursor, Microsoft Copilot and every other client.
Does the Power BI MCP connector work with Gemini, Codex, Claude Code or other MCP clients?
Yes. Power BI is reached over the same MCP endpoint every client uses, so anything that speaks MCP can call it — Gemini, Codex, Claude Code, Windsurf, Cline, Zed and OpenCode among them — alongside Claude, ChatGPT, Cursor, Microsoft Copilot, and the Elaichi Agent. The tools on offer and the access behind them are identical whichever client asks. Only the setup screen differs.
Is Elaichi an alternative to Zapier MCP for Power BI?
Yes. Both let Claude, ChatGPT or Cursor use Power BI. Zapier MCP fits a team that already automates in Zapier, since each person signs in and acts as themselves in that account. Elaichi fits when IT wants one address for the whole company, per-tool rules by role, and a record of every Power BI call.
How is Elaichi different from Composio for Power BI?
Composio gives AI agents tools and sign-in handling across 1,000+ apps, for developers building agents or people using an assistant, billed per tool call. Elaichi gives a company's own people governed access to Power BI: one address, restrictions per role or user, and $15 per user per month. Both have role permissions and a log of every call.
Put Power BI in front of your team
14 days of Black, no credit card. Connect it once and pick what each team can call.
When the trial ends, nothing is deleted. You move to the free Personal plan, and connections, roles and the audit log stay where they are.
Add one link to your AI app
The same link for everyone on your team.
https://api.elaichi.ai/mcp
ChatGPT
Claude
Cursor
Microsoft Copilot