PowerBI MCP Server
CommunityMCP server by gurvinder-dhillon · updated · ★ 0
PowerBI REST API integration. Query workspaces, datasets, and execute DAX queries via MCP. PowerBI MCP Server is a community project by gurvinder-dhillon, not verified by a company domain.
Last commit 260 days ago
MIT: permissive, fine for commercial use
Clear description, published package or server URL, original repository
Not checked yet. What we check
What you need
| Setting | Needed | What it is |
|---|---|---|
POWERBI_Environment variable | Required | Azure AD Tenant ID for PowerBI authentication |
POWERBI_Environment variable | Required | Azure AD Application (Client) ID with PowerBI API access |
POWERBI_Environment variable, secret | Required | Azure AD Client Secret for service principal authentication |
From the publisher's entry in the official MCP Registry. Required settings are already in the install config below as placeholders.
Install PowerBI MCP Server
Built from the published package, never by AIclaude mcp add powerbi-mcp-server -e POWERBI_TENANT_ID=YOUR_POWERBI_TENANT_ID -e POWERBI_CLIENT_ID=YOUR_POWERBI_CLIENT_ID -e POWERBI_CLIENT_SECRET=YOUR_POWERBI_CLIENT_SECRET -- uvx powerbi-mcpRun in your terminal. Add --scope user to use it in every project.
{
"mcpServers": {
"powerbi-mcp-server": {
"command": "uvx",
"args": [
"powerbi-mcp"
],
"env": {
"POWERBI_TENANT_ID": "YOUR_POWERBI_TENANT_ID",
"POWERBI_CLIENT_ID": "YOUR_POWERBI_CLIENT_ID",
"POWERBI_CLIENT_SECRET": "YOUR_POWERBI_CLIENT_SECRET"
}
}
}
}Settings, Developer, Edit config. Paste into claude_desktop_config.json and restart.
{
"mcpServers": {
"powerbi-mcp-server": {
"command": "uvx",
"args": [
"powerbi-mcp"
],
"env": {
"POWERBI_TENANT_ID": "YOUR_POWERBI_TENANT_ID",
"POWERBI_CLIENT_ID": "YOUR_POWERBI_CLIENT_ID",
"POWERBI_CLIENT_SECRET": "YOUR_POWERBI_CLIENT_SECRET"
}
}
}
}Add to ~/.cursor/mcp.json (all projects) or .cursor/mcp.json (this project).
{
"servers": {
"powerbi-mcp-server": {
"command": "uvx",
"args": [
"powerbi-mcp"
],
"env": {
"POWERBI_TENANT_ID": "YOUR_POWERBI_TENANT_ID",
"POWERBI_CLIENT_ID": "YOUR_POWERBI_CLIENT_ID",
"POWERBI_CLIENT_SECRET": "YOUR_POWERBI_CLIENT_SECRET"
}
}
}
}Add to .vscode/mcp.json. VS Code uses "servers", not "mcpServers".
codex mcp add powerbi-mcp-server --env POWERBI_TENANT_ID=YOUR_POWERBI_TENANT_ID --env POWERBI_CLIENT_ID=YOUR_POWERBI_CLIENT_ID --env POWERBI_CLIENT_SECRET=YOUR_POWERBI_CLIENT_SECRET -- uvx powerbi-mcp{
"mcpServers": {
"powerbi-mcp-server": {
"command": "uvx",
"args": [
"powerbi-mcp"
],
"env": {
"POWERBI_TENANT_ID": "YOUR_POWERBI_TENANT_ID",
"POWERBI_CLIENT_ID": "YOUR_POWERBI_CLIENT_ID",
"POWERBI_CLIENT_SECRET": "YOUR_POWERBI_CLIENT_SECRET"
}
}
}
}Add to ~/.gemini/config/mcp_config.json (all projects) or .agents/mcp_config.json (this project).
gemini mcp add powerbi-mcp-server uvx powerbi-mcpGemini CLI was replaced by Antigravity CLI in June 2026 and remains only for enterprise licences and paid API keys.
MCP servers run with your permissions and can read what you give them access to. Some need an API key: check the README and add it under env in the powerbi-mcp-server block.
Weekly newsletter
Like PowerBI MCP Server? Get the best new MCP servers every week
The best new tools, security warnings before you install something risky, and one practical tip. Free, three minute read.
Alternatives to PowerBI MCP Server
All alternatives →The Power BI Authoring MCP server lets an AI agent create and change Power BI semantic models.
Agent-Native Amplitude/Mixpanel - connect data sources, prompt for charts
Google Ads, Meta Ads, Google Analytics (GA4) & Search Console MCP server by Ryze AI
A Model Context Protocol (MCP) server that provides chat functionality with Cube's AI agent for analytics and data exploration
Create and edit Excel files with AI: charts, PivotTables, formulas. No Excel needed.
MCP server for AI-assisted Deepnote notebook creation and manipulation
PowerBI MCP Server: common questions
How do I install PowerBI MCP Server?
In Claude Code run claude mcp add powerbi-mcp-server -e POWERBI_TENANT_ID=YOUR_POWERBI_TENANT_ID -e POWERBI_CLIENT_ID=YOUR_POWERBI_CLIENT_ID -e POWERBI_CLIENT_SECRET=YOUR_POWERBI_CLIENT_SECRET -- uvx powerbi-mcp. For Claude Desktop, Cursor and VS Code, paste the config shown above and restart. See the install guides.
Is PowerBI MCP Server the official server?
PowerBI MCP Server is a community project by gurvinder-dhillon, not verified by a company domain.
Is PowerBI MCP Server free?
The code is published under the MIT licence. The service it connects to may have its own pricing.
Is PowerBI MCP Server safe to use?
It scores 21 of 100. Grades: maintenance D, licence A, quality C. The security check has not run for it yet. Review the code before you install. How grades work.
What are alternatives to PowerBI MCP Server?
Similar MCP servers: Power BI Authoring MCP Server (Local), Agent-Native Analytics, Google Ads + Meta Ads + SEO/GEO MCP, Cube Dev MCP Server.
Does PowerBI MCP Server work with ChatGPT?
Not directly. It runs locally, and ChatGPT only connects to remote servers with a URL. Use it in Claude Code, Claude Desktop, Cursor, VS Code or Codex.
