PowerBI REST API integration. Query workspaces, datasets, and execute DAX queries via MCP.
Config is the same across clients — only the file and path differ.
{
"mcpServers": {
"powerbi-mcp": {
"env": {
"POWERBI_CLIENT_ID": "your-client-id-here",
"POWERBI_TENANT_ID": "your-tenant-id-here",
"POWERBI_CLIENT_SECRET": "your-client-secret-here"
},
"args": [
"powerbi-mcp"
],
"command": "uvx"
}
}
}Are you the author?
Add this badge to your README to show your security score and help users find safe servers.
A Model Context Protocol (MCP) server that provides tools for interacting with PowerBI REST APIs. This server enables AI assistants like Claude to query PowerBI workspaces, datasets, and execute DAX queries.
No automated test available for this server. Check the GitHub README for setup instructions.
Five weighted categories — click any category to see the underlying evidence.
No known CVEs.
No package registry to scan.
Click any tool to inspect its schema.
Be the first to review
Have you used this server?
Share your experience — it helps other developers decide.
Sign in to write a review.
Others in analytics / data
Query and manage PostgreSQL databases directly from AI assistants
MCP Server for GCP environment for interacting with various Observability APIs.
⚡ A Simple / Speedy / Secure Link Shortener with Analytics, 100% run on Cloudflare.
🔥 Official Firecrawl MCP Server - Adds powerful web scraping and search to Cursor, Claude and any other LLM clients.
MCP Security Weekly
Get CVE alerts and security updates for Powerbi MCP Server and similar servers.
Start a conversation
Ask a question, share a tip, or report an issue.
Sign in to join the discussion.
A Model Context Protocol (MCP) server that provides tools for interacting with PowerBI REST APIs. This server enables AI assistants like Claude to query PowerBI workspaces, datasets, and execute DAX queries.
[!WARNING] Security Best Practices
- Never commit credentials to version control
- Store credentials in
.envfiles (add to.gitignore)- Rotate client secrets regularly in Azure AD
- Use least-privilege access (only grant necessary workspace permissions)
- This server has read/write access to PowerBI datasets - use with caution
See all available tools below.
| Scenario | Example Prompt |
|---|---|
| Explore available data | "What workspaces do I have access to?" |
| Discover reports | "What reports are available in my workspace?" |
| Understand data schema | "Show me the schema for dataset [dataset-name]" |
| Monitor data freshes | "When was this dataset last refreshed?" |
| Check parameters | "What parameters does this dataset accept?" |
| Query data with DAX | "Run a DAX query to get top 10 sales by region from [dataset]" |
| Analyze data quality | "What tables are in the Sales dataset?" |
| Extract insights | "Get the list of all measures in the Financial dataset" |
Before installing the server, you need to set up an Azure AD application with PowerBI access.
After registration, collect these values:
[!NOTE] Service principals can access workspaces where they've been granted explicit permissions (Admin, Member, or Contributor roles).
For each workspace you want to access:
Once published to PyPI, this is the simplest installation method.
Add the following to your MCP client configuratio