Log inSubmit server
PowerBI MCP Server logo

PowerBI MCP Server

Connects AI assistants to Power BI REST APIs for workspace discovery, dataset inspection, and DAX queries.

InstallRepositoryWebsite
Full README Compare alternatives Embed widget Claim this listing

Install PowerBI MCP Server

Pick your client, then add it in one click or paste the config.

STDIOPython
~/Library/Application Support/Claude/claude_desktop_config.json
claude_desktop_config.json
{
  "mcpServers": {
    "powerbi-mcp-server": {
      "command": "uvx",
      "args": [
        "powerbi-mcp"
      ],
      "env": {
        "POWERBI_TENANT_ID": "YOUR_VALUE_HERE",
        "POWERBI_CLIENT_ID": "YOUR_VALUE_HERE",
        "POWERBI_CLIENT_SECRET": "YOUR_VALUE_HERE"
      }
    }
  }
}

Settings → Developer → Edit Config, merge this into mcpServers, then fully quit and reopen Claude Desktop.

Values are written into the snippet above so you can paste it as is. They never leave your browser.

We couldn’t confirm it starts correctly

We ran the install command but it didn't respond within our test window — this can mean a slow first-time install rather than a real problem.

uvx powerbi-mcp

Process exited before answering initialize.

This is an experimental automated check and can have false negatives — missing environment variables, a slow cold install, etc. It doesn’t necessarily mean something’s wrong. Last checked 2d ago.

Overview

PowerBI MCP Server MCP server exposes Power BI REST API operations through MCP tools for discovering workspaces, datasets, and dataset metadata. It authenticates with an Azure AD service principal using tenant, client, and secret environment variables. Use it when an AI assistant needs to inspect accessible Power BI data or execute DAX queries without switching to the Power BI interface. Workspace access must be granted explicitly to the registered application.

Use cases

  • Discover accessible Power BI workspaces
  • Inspect dataset schemas and metadata
  • Execute DAX queries against datasets
  • Check dataset refreshes and parameters
  • Retrieve tables, measures, and reports

Key features

  • Power BI REST API access over MCP
  • Workspace and dataset discovery
  • Dataset identifier and detail lookup
  • DAX query execution
  • Azure AD service-principal authentication
  • Schema and metadata inspection

Tools6

What PowerBI MCP Server lets your agent do. Expand a tool for its parameters.

Self-reported~12 tokens of context

Security & health

What it can reach and how reliably it runs — from our own checks, not the maintainer’s claims.

ActiveLast checked 1d ago

Recent health check succeeded.

5/5 checks healthy over the last 41d

Supply-chain signal

No high-severity advisories surfaced by our automated scan.

Critical 0High 0Medium 0Low 0

Scanned 15d ago via OSV.dev · powerbi-mcp (PyPI)

Adoption & maintenance

Factual signals from GitHub, npm, and our automated checks — not a rating.

Last commit8mo agoMost recent push to the default branch.
Install checkInconclusiveDidn't respond in our test window — often a slow first install.
Tools exposed6Callable tools this server registers over MCP.
Directory activity3 viewsConfig copies, upvotes, and views on AllMCPs.

How PowerBI MCP Server works

What PowerBI MCP Server MCP server does

PowerBI MCP Server MCP server connects an MCP-compatible AI assistant to Power BI REST APIs. It supports discovery and analysis tasks across workspaces and datasets, including identifying available reports, examining dataset schemas, checking refresh information, reviewing parameters, and retrieving measures or tables.

The server is intended for Power BI environments where an Azure AD application can be granted access to the required workspaces. It can execute DAX queries against datasets available to that application, making it suitable for conversational data exploration and targeted data extraction.

How it works

PowerBI MCP Server MCP server uses an Azure AD service principal for authentication. The client supplies a tenant ID, application client ID, and client secret through environment variables. The application must also be enabled for Power BI API use in the Power BI Admin Portal and assigned a workspace role such as Admin, Member, or Contributor.

After authentication, an MCP client can call the server’s tools to identify workspaces and datasets, obtain identifiers, request dataset details, format inputs, and submit DAX queries. The exact data available depends on the workspaces and datasets that the service principal can access.

Setup and configuration

Create an app registration in Azure and collect its directory or tenant ID, application or client ID, and client secret value. Enable service principals for Power BI APIs, then add the application to each workspace it should access. The documented workspace roles are Admin, Member, and Contributor.

The required environment variables are:

  • POWERBI_TENANT_ID
  • POWERBI_CLIENT_ID
  • POWERBI_CLIENT_SECRET

The recommended package-based setup runs the server with uvx powerbi-mcp. The repository also documents running the package directly from GitHub with uvx, or running a local checkout with uv after uv sync. Claude Desktop, Claude Code, and OpenCode configuration examples are provided. With Claude Code, credentials can be stored in a .env file in the project’s working directory; that file should not be committed.

Tools and capabilities

The listed MCP tools are:

  • workspace_id: resolves or works with workspace identifiers.
  • dataset_id: resolves or works with dataset identifiers.
  • format: formats requests or query-related input.
  • dax_query: executes DAX queries against Power BI datasets.

Together, these capabilities support workspace and dataset discovery, schema-oriented inspection, and DAX-based retrieval. The README specifically describes use cases such as finding accessible workspaces, listing reports, inspecting tables and columns, checking refreshes and parameters, and getting measures from a dataset.

Limitations and notes

Access is limited by the permissions granted to the Azure AD service principal. Power BI administrator settings and explicit workspace membership are required before protected workspaces can be queried. The README warns that the server has read/write access to Power BI datasets, so credentials should be protected, client secrets rotated regularly, and permissions kept to the minimum required scope.

Confirm those details in the repository before relying on the server for production workflows.

Read the full README View source on GitHub

Reviews

No reviews yet — be the first to share how it worked for you.

Frequently Asked Questions about PowerBI MCP Server

PowerBI MCP Server is an MCP server that connects AI assistants to Power BI REST APIs through Azure AD service-principal credentials. Its main tools discover workspaces and datasets, inspect dataset details, resolve workspace and dataset IDs, format requests, and execute DAX queries against accessible Power BI data.

Install it with the documented `uvx powerbi-mcp` configuration, or run it from GitHub with `uvx` or from a local clone with `uv`. Add the required Power BI environment variables to your MCP client configuration, then restart the client.

It requires an Azure AD tenant ID, client ID, and client secret. Set them as `POWERBI_TENANT_ID`, `POWERBI_CLIENT_ID`, and `POWERBI_CLIENT_SECRET`, then enable the service principal for Power BI APIs and grant it access to the target workspaces.

Yes, it works with Claude Desktop through a local MCP configuration using `uvx powerbi-mcp`. The configuration passes the three Power BI credential variables to the server, and the client should be restarted after the configuration is added.

Related MCP servers

All in Data Visualization All alternatives
Add a badge to your READMEShow it’s listed — live SVG, Markdown or HTML.

AllMCPs Directory Badge

Full Badge Customizer

Showcase your server listing on GitHub or your project documentation. Embed this dynamic SVG badge to highlight official listing status and live engagement.

Badge Style:
Live Dynamic SVG PreviewPowerBI MCP Server AllMCPs Directory Badge
Markdown (GitHub README)
[![AllMCPs](https://allmcps.com/api/badge/powerbi-mcp-server?style=directory)](https://allmcps.com/mcp/powerbi-mcp-server)
HTML Embed
<a href="https://allmcps.com/mcp/powerbi-mcp-server"><img src="https://allmcps.com/api/badge/powerbi-mcp-server?style=directory" alt="PowerBI MCP Server on AllMCPs" /></a>