# Powerbi

> Powerbi is an open-source MCP server for analytics and data. MCP server that connects AI clients to the Power BI API for analytics workflows. It runs locally on your machine and is started by your AI client.

- **Kind:** MCP server
- **Pricing:** Open source
- **Platforms:** CLI, API, self-hosted
- **Repository:** https://github.com/asklokesh/powerbi-mcp-server
- **MCP Registry name:** io.github.asklokesh/powerbi-mcp-server
- **Categories:** [analytics and data](https://ai-powered.com/categories/analytics-and-data)
- **Listing updated:** 2026-11-18

## About

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.

## Features

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

## Install

### Claude Code (Terminal)

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

### Claude Desktop (claude_desktop_config.json)

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

### Cursor (~/.cursor/mcp.json)

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

### VS Code (.vscode/mcp.json)

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

### Windsurf (~/.codeium/windsurf/mcp_config.json)

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

### Other clients (your client's MCP settings (most use this shape))

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

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

## Alternatives

- [Tableau](https://ai-powered.com/mcp/tableau): Tableau is an open-source MCP server for analytics and data.
- [Horizun PBI MCP](https://ai-powered.com/mcp/horizun-pbi-mcp): Horizun PBI MCP is a free MCP server for analytics and data.
- [PyPI Release Tracker — new Python packages & dependency updates (pypiwatch)](https://ai-powered.com/mcp/pypi-release-tracker-new-python-packages-and-dependency-upda): PyPI Release Tracker — new Python packages & dependency updates (pypiwatch) is an MCP server for analytics and data.
- [Greenlake Reporting MCP](https://ai-powered.com/mcp/greenlake-reporting-mcp): Greenlake Reporting MCP is an open-source MCP server for analytics and data.
- [Klipfolio MCP by usefulapi](https://ai-powered.com/mcp/klipfolio-mcp-by-usefulapi): Klipfolio MCP by usefulapi is a freemium MCP server for analytics and data.

---
Source: https://ai-powered.com/mcp/powerbi
