Skip to content
MCP server

Powerbi

MCP server that connects AI clients to the Power BI API for analytics workflows

Runs locallyStatus and history
Install
Pricing
Open source
Platforms
CLI, API, self-hosted
Runs
Locally
Version
0.1.0
Listing updated
today

Similar MCP servers

About Powerbi

Powerbi is an open-source MCP server for analytics and data. It runs locally on your machine and is started by your AI client.

The README describes this as a Model Context Protocol server for wiring Power BI into GenAI applications. It is distributed as a Python package on PyPI and can also be installed from source, with an editable pip install from the GitHub repository.

According to the README, it runs over stdio and needs a Power BI API key plus an optional API URL set through environment variables or a .env file. The listed features cover broad Power BI API coverage, several authentication methods, rate limiting, retry handling and async support.

The project suits developers who want an AI assistant to query or manage Power BI resources through the API. The README is brief and does not enumerate individual tools, so check the repository before relying on specific operations.

Install

Run in a terminal

claude mcp add powerbi-mcp-server --env POWERBI_API_KEY='<POWERBI_API_KEY>' -- uvx powerbi-mcp-server

Add to claude_desktop_config.json

{
  "mcpServers": {
    "powerbi-mcp-server": {
      "command": "uvx",
      "args": [
        "powerbi-mcp-server"
      ],
      "env": {
        "POWERBI_API_KEY": "<POWERBI_API_KEY>"
      }
    }
  }
}

Add to ~/.cursor/mcp.json

{
  "mcpServers": {
    "powerbi-mcp-server": {
      "command": "uvx",
      "args": [
        "powerbi-mcp-server"
      ],
      "env": {
        "POWERBI_API_KEY": "<POWERBI_API_KEY>"
      }
    }
  }
}

Add to .vscode/mcp.json

{
  "servers": {
    "powerbi-mcp-server": {
      "type": "stdio",
      "command": "uvx",
      "args": [
        "powerbi-mcp-server"
      ],
      "env": {
        "POWERBI_API_KEY": "<POWERBI_API_KEY>"
      }
    }
  }
}

Add to ~/.codeium/windsurf/mcp_config.json

{
  "mcpServers": {
    "powerbi-mcp-server": {
      "command": "uvx",
      "args": [
        "powerbi-mcp-server"
      ],
      "env": {
        "POWERBI_API_KEY": "<POWERBI_API_KEY>"
      }
    }
  }
}

Add to your client's MCP settings (most use this shape)

{
  "mcpServers": {
    "powerbi-mcp-server": {
      "command": "uvx",
      "args": [
        "powerbi-mcp-server"
      ],
      "env": {
        "POWERBI_API_KEY": "<POWERBI_API_KEY>"
      }
    }
  }
}

Using several servers? Build one config file with the MCP config generator.

Configuration

  • POWERBI_API_KEYAPI Key for POWERBIRequired
  • POWERBI_API_URLAPI URL for POWERBI

What it does

Broad Power BI API coverage
The README says the server covers a wide range of the Power BI API surface.
Multiple authentication methods
Several authentication options are offered for connecting to Power BI.
Rate limiting built in
Requests are rate limited, which the README presents as suitable for enterprise use.
Retry and error handling
The README describes full error handling with retry logic for failed calls.
Async support
Asynchronous operation is offered for better performance under load.
Stdio transport
The registry entry lists stdio as the transport for connecting MCP clients.

Good for

  • Letting an AI assistant query Power BI datasets and reports through the API
  • Automating Power BI administration tasks from an MCP-compatible client
  • Adding business analytics context to GenAI applications
  • Prototyping conversational access to Power BI data for developers

Pricing

Open source

Free and open source under the MIT License.

Powerbi FAQ

How do I install the Power BI MCP server?

The README shows installation with pip install powerbi-mcp-server, or by cloning the GitHub repository and running pip install -e .

What credentials does it need?

The registry entry lists POWERBI_API_KEY as a required secret and POWERBI_API_URL as an optional variable.

What license does it use?

The README states the project is released under the MIT License.

Is Powerbi free?

Yes. Powerbi is open source, so you can use and self-host it for free.

How do I add Powerbi to Claude Code?

Run this command in your terminal: claude mcp add powerbi-mcp-server --env POWERBI_API_KEY='<POWERBI_API_KEY>' -- uvx powerbi-mcp-server

What are the best alternatives to Powerbi?

The closest alternatives to Powerbi are Tableau, Horizun PBI MCP, PyPI Release Tracker — new Python packages & dependency updates (pypiwatch), Greenlake Reporting MCP and Klipfolio MCP by usefulapi.

Where this comes from

  • Description: written from the project's README and its MCP Registry entry.
  • Install steps: from the official MCP Registry entry.

How AIPoweredBot checks servers