PowerBI MCP Server
PowerBI REST API integration. Query workspaces, datasets, and execute DAX queries via MCP.
- Pricing
- Open source
- Runs
- Locally
- Version
- 0.1.2
- Listing updated
- 5 days ago
About PowerBI MCP Server
PowerBI MCP Server is an open-source MCP server. It runs locally on your machine and is started by your AI client.
Install
Run in a terminal
claude mcp add powerbi-mcp --env POWERBI_TENANT_ID='<POWERBI_TENANT_ID>' --env POWERBI_CLIENT_ID='<POWERBI_CLIENT_ID>' --env POWERBI_CLIENT_SECRET='<POWERBI_CLIENT_SECRET>' -- uvx powerbi-mcpAdd to claude_desktop_config.json
{
"mcpServers": {
"powerbi-mcp": {
"command": "uvx",
"args": [
"powerbi-mcp"
],
"env": {
"POWERBI_TENANT_ID": "<POWERBI_TENANT_ID>",
"POWERBI_CLIENT_ID": "<POWERBI_CLIENT_ID>",
"POWERBI_CLIENT_SECRET": "<POWERBI_CLIENT_SECRET>"
}
}
}
}Add to ~/.cursor/mcp.json
{
"mcpServers": {
"powerbi-mcp": {
"command": "uvx",
"args": [
"powerbi-mcp"
],
"env": {
"POWERBI_TENANT_ID": "<POWERBI_TENANT_ID>",
"POWERBI_CLIENT_ID": "<POWERBI_CLIENT_ID>",
"POWERBI_CLIENT_SECRET": "<POWERBI_CLIENT_SECRET>"
}
}
}
}Add to .vscode/mcp.json
{
"servers": {
"powerbi-mcp": {
"type": "stdio",
"command": "uvx",
"args": [
"powerbi-mcp"
],
"env": {
"POWERBI_TENANT_ID": "<POWERBI_TENANT_ID>",
"POWERBI_CLIENT_ID": "<POWERBI_CLIENT_ID>",
"POWERBI_CLIENT_SECRET": "<POWERBI_CLIENT_SECRET>"
}
}
}
}Add to ~/.codeium/windsurf/mcp_config.json
{
"mcpServers": {
"powerbi-mcp": {
"command": "uvx",
"args": [
"powerbi-mcp"
],
"env": {
"POWERBI_TENANT_ID": "<POWERBI_TENANT_ID>",
"POWERBI_CLIENT_ID": "<POWERBI_CLIENT_ID>",
"POWERBI_CLIENT_SECRET": "<POWERBI_CLIENT_SECRET>"
}
}
}
}Add to your client's MCP settings (most use this shape)
{
"mcpServers": {
"powerbi-mcp": {
"command": "uvx",
"args": [
"powerbi-mcp"
],
"env": {
"POWERBI_TENANT_ID": "<POWERBI_TENANT_ID>",
"POWERBI_CLIENT_ID": "<POWERBI_CLIENT_ID>",
"POWERBI_CLIENT_SECRET": "<POWERBI_CLIENT_SECRET>"
}
}
}
}Using several servers? Build one config file with the MCP config generator.
Configuration
POWERBI_TENANT_IDAzure AD Tenant ID for PowerBI authenticationRequiredPOWERBI_CLIENT_IDAzure AD Application (Client) ID with PowerBI API accessRequiredPOWERBI_CLIENT_SECRETAzure AD Client Secret for service principal authenticationRequired
Pricing
Open source
PowerBI MCP Server FAQ
Is PowerBI MCP Server free?
Yes. PowerBI MCP Server is open source, so you can use and self-host it for free.
How do I add PowerBI MCP Server to Claude Code?
Run this command in your terminal: claude mcp add powerbi-mcp --env POWERBI_TENANT_ID='<POWERBI_TENANT_ID>' --env POWERBI_CLIENT_ID='<POWERBI_CLIENT_ID>' --env POWERBI_CLIENT_SECRET='<POWERBI_CLIENT_SECRET>' -- uvx powerbi-mcp
Where this comes from
- Description: from the official MCP Registry entry.
- Install steps: from the official MCP Registry entry.