Powerbi
MCP server that connects AI clients to the Power BI API for analytics workflows
- 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-serverAdd 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 POWERBIRequiredPOWERBI_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.
