Skip to content

BI

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
ChatGPT Elaichi connected

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
Ask anything…
Governance / Audit log Last 24 hours
Power BI Get single Power BI workspace by ID Emily Carter · ChatGPT · 9:41 AM Done
Power BI List all Power BI workspaces Emily Carter · ChatGPT · 9:41 AM Done
Power BI List all Power BI users Emily Carter · ChatGPT · 9:41 AM Done
Power BI Update a Power BI user by ID Megan Brooks · Claude · 9:38 AM Done
Power BI Create a Power BI user Ryan Hayes · Cursor · 9:35 AM Done

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. 1

    Open Customize, then Connectors.

  2. 2

    Press Add.

  3. 3

    Name it, paste the MCP server URL, then Continue.

    https://api.elaichi.ai/mcp
  4. 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. 1

    In a terminal, run claude mcp add with the endpoint.

    https://api.elaichi.ai/mcp
  2. 2

    Start Claude Code and run /mcp.

  3. 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. 1

    Open Plugins, then press the + button.

  2. 2

    Name it and paste the endpoint into Server URL.

    https://api.elaichi.ai/mcp
  3. 3

    Leave Authentication on OAuth, then tick the risk acknowledgement.

  4. 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. 1

    Open ~/.cursor/mcp.json.

  2. 2

    Add the endpoint under mcpServers.

    https://api.elaichi.ai/mcp
  3. 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. 1

    In Copilot Studio, open your agent, then Tools, Add a tool, New tool and Model Context Protocol.

  2. 2

    Paste the endpoint into Server URL, choose OAuth 2.0, then Dynamic discovery, and press Create.

    https://api.elaichi.ai/mcp
  3. 3

    Create a new connection, sign in and approve, then press Add to agent.

  4. 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. 1

    Add the endpoint as a remote MCP server.

    https://api.elaichi.ai/mcp
  2. 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”

See all 174 Power BI tools →

What connecting Power BI gets you

6 screens from Elaichi, each doing one job for your Power BI account.

Elaichi Agent

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.

ElaichiAI apps
Claude ChatGPT Cursor Microsoft Copilot

Copy the endpoint

https://api.elaichi.ai/mcp
Client Connected by Status Last used
Claude
E

Emily Carter

• Connected 4 minutes ago
Cursor
M

Megan Brooks

• Connected 2 hours ago
ChatGPT
R

Ryan Hayes

• Connected Yesterday

AI apps

One endpoint brings Power BI to every client.

Claude, ChatGPT and Cursor connect over OAuth, no SDK and no shared API key.

ElaichiTools
Tool Action Description
List all Power BI users List List users who have access to a Power BI workspace. Returns workspace user records with id and upstream-defined attributes. Required: workspace_id.
Delete a Power BI user by ID Delete Remove a user's permissions from a Power BI workspace. Returns an empty 204 response on success. Required: group_id and id.
Update a Power BI user by ID Update Update a principal's access right on a Power BI workspace. Returns an empty 200 response on success. Required: workspace_id, identifier, principalType, groupUserAccessRight.
Create a Power BI user Create Grant a user the specified permissions on a Power BI workspace (group). Accepts a GroupUser request body and returns an empty response on success (200 OK). Each workspace allows a maximum of 1,000 users or groups in workspace roles. Required: group_id, identifier, principalType, groupUserAccessRight.
List all Power BI workspaces List List Power BI workspaces (groups) in the organization. Returns workspace records including their id (UUID).

Tool catalog

174 Power BI tools, no custom code needed.

Workspaces, reports, dashboards, tiles, users and capacities, covered the day you connect.

ElaichiToolboxes
Name Source template Tools Created

Analytics toolbox

Power BI · workspaces and reports

Power BI starter 18 Mar 4, 2026

IT toolbox

Power BI · users and capacities

— 9 Mar 2, 2026

Finance toolbox

Power BI · reports and dashboards

— 24 Feb 27, 2026

Operations toolbox

Power BI · dashboards and tiles

Power BI starter 6 Feb 19, 2026

Data engineering toolbox

Power BI · refresh permissions and workloads

— 31 Jan 30, 2026

Sales toolbox

Power BI · app reports and dashboards

— 12 Jan 22, 2026

Toolboxes

Each team gets its own Power BI toolbox.

Analytics builds workspaces, IT manages users, Finance only finds reports.

ElaichiConnections
Connection Scope Status Access
PO

Power BI (Analytics)

Connected by Emily Carter

Personal • Active 1 team · 6 members
PO

Power BI (Finance)

Connected by Jake Morgan

Organization • Active 3 teams · 24 members
PO

Power BI (IT admin)

Connected by Megan Brooks

Organization • Active 2 teams · 11 members
PO

Power BI (Sales ops)

Connected by Tyler Reed

Personal • Needs re-auth 1 team · 3 members
PO

Power BI (EMEA reporting)

Connected by Ryan Hayes

Personal • Active Not shared
PO

Power BI (Executive dashboards)

Connected by Ashley Parker

Personal • Active 2 teams · 9 members

Shared connections

Share one Power BI connection, keep the credential.

Teammates work through the connection you set up without ever seeing a secret.

ElaichiAudit log
When Who What happened Type

2 minutes ago

Mar 6, 2026, 3:10 PM

E

Emily Carter

[email protected]

Restriction Created Access

8 minutes ago

Mar 6, 2026, 3:04 PM

J

Jake Morgan

[email protected]

Restriction Updated Access

14 minutes ago

Mar 6, 2026, 2:58 PM

M

Megan Brooks

[email protected]

Role Assigned Access

20 minutes ago

Mar 6, 2026, 2:52 PM

T

Tyler Reed

[email protected]

Power BI Users Updated MCP

26 minutes ago

Mar 6, 2026, 2:46 PM

R

Ryan Hayes

[email protected]

Power BI Workspaces Created MCP

32 minutes ago

Mar 6, 2026, 2:40 PM

A

Ashley Parker

[email protected]

Power BI Workspaces List Toolbox

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

  1. ✓

    Schedule

    Every weekday at 8:00 AM

    0.2s
  2. ✓

    Fetch workspaces

    Power BI

    1.4s
  3. ✓

    Group by owner

    Transform

    0.1s
  4. ✓

    Draft the digest

    Agent step

    Ran with 4 tools, returned a structured summary

    6.2s
  5. Approve the digest

    Needs approval

    Assigned to Jake Morgan

    Approve
  6. 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

Live

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.

Elaichi compared with Zapier MCP and Composio for Power BI, by what to check
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.

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 my team share one Power BI connection?

Yes. One person connects Power BI in Elaichi and shares the connection with a team, and nobody else handles a credential or sees a secret. Each person still signs in to Elaichi as themselves, so the audit log names who did what in Power BI, not just the account that was shared.

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