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

Source: https://elaichi.ai/connectors/powerbi/

## Facts

| | |
| --- | --- |
| Application | Power BI |
| Category | BI |
| AI tools | 174 |
| Authentication | Connects over OAuth |
| Bring your own OAuth app | No |
| MCP endpoint | https://api.elaichi.ai/mcp |
| Works with | Claude, ChatGPT, Cursor, Microsoft Copilot, any MCP client, and the Elaichi Agent |
| Tools advertised by name | No. Connected tools are never listed one by one, however few there are. The endpoint advertises `search_tools` and `execute_tool` instead |

## What you can ask once Power BI is connected

- 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

## Connect Power BI in Elaichi

This happens once for the organization, before any client is involved.

1. Open Connections, choose Add connection, and pick Power BI.
2. Optionally set Share with, then press Connect.
3. Approve it in Power BI. Power BI's own window opens. Whoever approves it decides what this connection can reach.

Credentials are vaulted and nobody, including the AI, reads them back. The connection becomes a toolbox immediately, so you can curate which Power BI tools are exposed, rename them, or freeze arguments before anyone points a client at it.

## Power BI MCP connector for Claude

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

1. Open Customize, then Connectors.
2. Press Add.
3. Name it, paste the MCP server URL, then Continue.
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

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

1. In a terminal, run `claude mcp add` with the endpoint.
2. Start Claude Code and run `/mcp`.
3. Pick elaichi, then sign in and approve in the browser.

```bash
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

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

1. Open Plugins, then press the + button.
2. Name it and paste the endpoint into Server URL.
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

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

1. Open `~/.cursor/mcp.json`.
2. Add the endpoint under `mcpServers`.
3. Reload Cursor, then sign in and approve.

Set up per machine, so repeat it on each computer you work from.

## Power BI MCP connector for Microsoft Copilot

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

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

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

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

1. Add the endpoint as a remote MCP server.
2. Sign in and approve.

The Elaichi Agent already has these tools, with nothing to set up.

## What the consent screen decides

Every scope the client asks for starts ticked except "Delete things", which you tick yourself. Calling a Power BI tool needs "Use your connected apps". Over MCP there is no trusted place to confirm a write in the moment, so the consent screen is the standing approval rather than a formality. Think hard before granting Use your connected apps, which can also delete in connected apps and cannot be undone.

## What teams do with Power BI through Elaichi

### Set up a workspace for a new project

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

### Find the month-end report without hunting

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

### Copy tiles onto a new dashboard

Operations. Clone the tiles from last quarter's dashboard onto a fresh one for this quarter so nobody rebuilds visuals by hand.

### Clean up users who no longer need access

IT. List every Power BI user, spot the ones who changed roles or left, and update or remove them in one pass.

### Check who can trigger refreshes

Data engineering. 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.

### Keep capacity workloads in balance

IT. Review the workloads on each Power BI capacity and adjust the settings when one workspace is crowding out the others.

## 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. Endpoint: 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](https://docs.zapier.com/mcp/get-started/quickstart), [security](https://docs.zapier.com/mcp/manage/security), [usage](https://docs.zapier.com/mcp/features/usage); Composio [docs](https://docs.composio.dev/docs/composio-connect), [gateway](https://composio.dev/mcp-gateway), [enterprise](https://composio.dev/enterprise), [pricing](https://composio.dev/pricing). Checked September 2026.

Longer take: [Zapier MCP alternative](/blog/zapier-mcp-alternative/) and [when you don't need an MCP gateway](/blog/when-you-dont-need-an-mcp-gateway/).

## Frequently asked questions

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

## All 174 Power BI tools

Every tool below is callable through https://api.elaichi.ai/mcp once Power BI is connected, subject to the toolbox it is in and the restrictions on the caller.

- **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).
- **Get single Power BI workspace by ID** (Get). Get a single Power BI workspace (group) by id. Returns the workspace record including its id (UUID). Required: id.
- **Create a Power BI workspace** (Create). Create a new workspace in Power BI. Returns: id, name, isReadOnly, isOnDedicatedCapacity, capacityId, dataflowStorageId, defaultDatasetStorageFormat, logAnalyticsWorkspace. Required: name.
- **Delete a Power BI workspace by ID** (Delete). Delete a Power BI workspace (group) by id. Returns an empty 200 response on success. Required: id.
- **Update a Power BI workspace by ID** (Update). Update a Power BI workspace (group) by id. Returns an empty 200 response on success. Requires id and a body of the properties to update: name and defaultDatasetStorageFormat (only name can be updated for Shared capacities; name must be unique inside the organization). Required: id.
- **List all Power BI refresh user permissions** (List). Trigger a refresh of user permissions in Power BI. This operation takes no input parameters and returns an empty 204 response on success.
- **Get single Power BI app dashboard by ID** (Get). Get a dashboard from a specified Power BI app by id. Returns: id, displayName, isReadOnly, app_id, webUrl, embedUrl, users, subscriptions. Required: id, dashboardId, app_id.
- **List all Power BI app dashboards** (List). List dashboards from a specified Power BI app. Returns dashboards with: id, displayName, isReadOnly, app_id, webUrl, embedUrl. Required: app_id.
- **Get single Power BI app report by ID** (Get). Get a specific Power BI report from a specified app by id. Returns: id, name, datasetId, app_id, description, reportType, originalReportId, isOwnedByMe, format, webUrl, embedUrl, users, subscriptions. Required: id, reportId, app_id.
- **List all Power BI app reports** (List). List Power BI reports from a specified app. Returns reports with id, name, reportType, webUrl, embedUrl. Required: app_id.
- **Get single Power BI capacitie workload by ID** (Get). Get the current state of a single workload in a Power BI capacity. Returns: name, state, maxMemoryPercentageSetByUser. Required: id, capacity_id. Not applicable to Gen2 capacities.
- **List all Power BI capacitie workloads** (List). List the current state of workloads in a Power BI capacity. Returns each workload's name, state, and maxMemoryPercentageSetByUser (percentage of maximum memory, returned when the workload is enabled). Required: capacity_id. Not applicable to Gen2 capacities.
- **Update a Power BI capacitie workload by ID** (Update). Update a workload's state for a specific Power BI capacity, enabling or disabling it and, when enabling, setting the percentage of maximum memory the workload can consume. Returns an empty response body on success. Workload APIs don't apply to Gen2 capacities. Required: capacity_id, workload_name, state.
- **Create a Power BI dashboard generate token** (Create). Generate an embed token to view a specific dashboard from a Power BI workspace. Returns: token, tokenId, expiration. Required: group_id, dashboard_id. Intended for the embed-for-your-customers scenario.
- **Power BI dashboard tiles clone** (Action). Clone a Power BI dashboard tile to another dashboard. Returns the cloned tile with: id, title, reportId, datasetId, embedUrl. Required: dashboard_id, tile_id, targetDashboardId. Cloning across workspaces without targetReportId and targetModelId removes the tile's report and dataset links.
- **Get single Power BI dashboard tile by ID** (Get). Get a specific tile within a Power BI dashboard. Returns: id, title, reportId, datasetId, rowSpan, colSpan, embedUrl, embedData. Titles edited in the report before the visual is added to the dashboard are not returned. Required: id, tileId, dashboard_id.
- **List all Power BI dashboard tiles** (List). List tiles within a Power BI dashboard. Returns tiles with: id, title, reportId, datasetId, rowSpan, colSpan, embedUrl, embedData. Required: dashboard_id. Titles edited in the report before the visual is added to the dashboard are not returned.
- **Power BI dashboard tiles dashboards clone** (Action). Clone a Power BI dashboard tile within the specified workspace into a target dashboard, optionally remapping its report or dataset. Returns: id, title, reportId, datasetId, rowSpan, colSpan, embedUrl, embedData. Required: group_id, dashboard_id, tile_id, targetDashboardId.
- **Get single Power BI dashboard tiles dashboard by ID** (Get). Get a single Power BI dashboard tile by id from the specified dashboard and workspace. Returns: id, title, reportId, datasetId, rowSpan, colSpan, embedUrl, embedData. Required: id, group_id, dashboard_id.
- **List all Power BI dashboard tiles dashboards** (List). List Power BI tiles within the specified dashboard and workspace. Returns tiles with id, title, reportId, datasetId, rowSpan, colSpan, embedUrl, and embedData. Required: group_id, dashboard_id.
- **List all Power BI dataflow datasources** (List). List Power BI data sources for a specified dataflow within a group. Returns: name, datasourceType, connectionString, connectionDetails, gatewayId, datasourceId. Required: group_id, dataflow_id. Deleted data sources still appear in the response.
- **Update a Power BI dataflow refresh schedule by ID** (Update). Create or update the refresh schedule for a specific Power BI dataflow. Returns an empty 200 response on success. Requires group_id (the workspace ID), dataflow_id, and a refresh schedule body. Required: group_id, dataflow_id, value.
- **Create a Power BI dataflow refresh** (Create). Trigger a refresh for the specified dataflow in a Power BI workspace. Returns an empty 200 response on success. Required: group_id, dataflow_id, notifyOption.
- **Create a Power BI dataflow save as native artifact** (Create). Save a Power BI Gen1 dataflow as a Gen2 (CI/CD) Fabric native artifact, optionally migrating its refresh schedule to a target workspace. Returns: artifactMetadata, errors. Required: group_id, gen1_dataflow_id. This is a preview API call.
- **List all Power BI dataflow transactions** (List). List Power BI dataflow transactions for a specified dataflow. Returns each transaction's id, refreshType, startTime, endTime, and status. Required: group_id, dataflow_id.
- **List all Power BI dataflow upstream dataflows** (List). List upstream dataflows for a specified Power BI dataflow. Returns: targetDataflowId, group_id. Required: group_id, dataflow_id.
- **Power BI dataflows transactions cancel** (Cancel). Attempts to cancel the specified dataflow transaction in Power BI. Returns the transaction status including id and status. Required: group_id, transaction_id.
- **List all Power BI dataset datasources** (List). List the data sources of a dataset in Power BI (My workspace). Returns each datasource's name, datasourceType, connectionString, connectionDetails, gatewayId, and datasourceId. Required: dataset_id.
- **List all Power BI dataset datasources datasets** (List). List the data sources for a specified dataset in a Power BI workspace. Returns: name, connectionString, datasourceType, connectionDetails, gatewayId, datasourceId. Required: group_id, dataset_id.
- **Power BI dataset direct query refresh schedules bulk update** (Search). Update the DirectQuery or LiveConnection refresh schedule for a Power BI dataset in My workspace. Returns an empty 200 response on success. Send either days and times or a frequency, but not both; setting frequency overwrites days and times. Required: dataset_id, value.
- **Get single Power BI dataset direct query refresh schedule by ID** (Get). Get the DirectQuery or LiveConnection refresh schedule for a dataset in Power BI My workspace. Returns: frequency, days, times, localTimeZoneId. Required: id.
- **List all Power BI dataset direct query refresh schedules** (List). Get the DirectQuery or LiveConnection refresh schedule for a dataset in a specified Power BI workspace. Returns: frequency, days, times, localTimeZoneId. Required: group_id, dataset_id.
- **Update a Power BI dataset direct query refresh schedule by ID** (Update). Update the DirectQuery or LiveConnection refresh schedule for a Power BI dataset in a specified workspace. Returns an empty 200 response on success. Send either days and times or a frequency, but not both; setting frequency overwrites days and times. Required: group_id, dataset_id, value.
- **Create a Power BI dataset execute query** (Create). Execute a DAX query against a Power BI dataset. Returns: informationProtectionLabel, results, error. Required: dataset_id, queries. Limits: one query and one table request per call, max 100,000 rows or 1,000,000 values and 15MB per query; DAX only (no MDX/DMV).
- **Create a Power BI dataset execute queries executequery** (Create). Execute Data Analysis Expressions (DAX) queries against a Power BI dataset in a workspace. Returns: informationProtectionLabel, results, error. Required: group_id, dataset_id, queries.
- **Create a Power BI dataset generate token** (Create). Generate a Power BI embed token for a specific dataset in a workspace. Returns: token, tokenId, expiration. Required: group_id, dataset_id. Only relevant to the embed-for-your-customers scenario.
- **List all Power BI dataset parameters** (List). List parameters for a specified dataset in Power BI (My workspace). Returns: name, type, currentValue, isRequired, suggestedValues. Required: dataset_id. Datasets with SQL, Oracle, Teradata, or SAP HANA DirectQuery connections or modified via the XMLA endpoint aren't supported.
- **List all Power BI dataset parameters datasets** (List). List parameters for a dataset in a Power BI workspace. Returns: name, type, currentValue, isRequired, suggestedValues. Required: group_id, dataset_id.
- **Power BI dataset refresh schedules bulk update** (Refresh). Update the refresh schedule of a Power BI dataset in My workspace. Returns an empty 200 response on success. Required: dataset_id, value.
- **Get single Power BI dataset refresh schedule by ID** (Get). Get the refresh schedule for a dataset from My workspace in Power BI. Returns: days, times, enabled, localTimeZoneId, notifyOption. Required: id.
- **List all Power BI dataset refresh schedules** (List). Get the refresh schedule for a dataset in a specific Power BI workspace. Returns: days, times, enabled, localTimeZoneId, notifyOption. Required: group_id and dataset_id.
- **Update a Power BI dataset refresh schedule by ID** (Update). Update the refresh schedule of a Power BI dataset in a specific workspace. Returns an empty 200 response on success. Required: group_id, dataset_id, value.
- **Create a Power BI dataset refresh** (Create). Trigger a refresh of a Power BI dataset from My workspace. Returns an empty 202 Accepted response on success. Shared capacities allow only notifyOption in the body and max eight refresh requests per day; setting any other body field triggers an enhanced refresh. Required: dataset_id, notifyOption.
- **Delete a Power BI dataset refresh by ID** (Delete). Cancel an in-progress refresh of a Power BI dataset. Returns an empty 200 response on success. Required: id, refreshId, dataset_id.
- **Get single Power BI dataset refresh by ID** (Get). Get execution details of a specific refresh operation for a Power BI dataset from My workspace. Returns: startTime, endTime, type, commitMode, status, extendedStatus, currentRefreshType, numberOfAttempts, objects, messages, refreshAttempts, initiatedBy, serviceExceptionJson. Required: id, refreshId, dataset_id.
- **List all Power BI dataset refreshes** (List). List the refresh history for a Power BI dataset from My workspace. Returns: startTime, endTime, type, commitMode, status, extendedStatus, currentRefreshType, numberOfAttempts, objects, messages, refreshAttempts, initiatedBy, serviceExceptionJson. Required: dataset_id. Only entries less than 3 days old are kept (up to 60).
- ...and 124 more tools. Call `tools/list` via the MCP endpoint, or see the full catalog via the API, for the complete set.
