PowerBI REST API integration. Query workspaces, datasets, and execute DAX queries via MCP.
MCPpedia last refreshed this data
Powerbi MCP Server is an MCP server that PowerBI REST API integration. Query workspaces, datasets, and execute DAX queries via MCP. Its tool list has not been published yet over stdio, requires no API key, and scores 73/100 on MCPpedia's security, maintenance and efficiency rubric.
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.
PowerBI REST API integration. Query workspaces, datasets, and execute DAX queries via MCP.
Run this in your terminal to verify the server starts. Then let us know if it worked - your result helps other developers.
uvx 'powerbi-mcp' 2>&1 | head -1 && echo "✓ Server started successfully"
After testing, let us know if it worked:
Five weighted categories - click any category to see the underlying evidence.
No known CVEs.
Checked powerbi-mcp against OSV.dev.
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
Token-efficient database MCP server for PostgreSQL, MySQL, MariaDB, SQL Server, Oracle, SQLite
Manage Supabase projects — databases, auth, storage, and edge functions
Firecrawl, the context API for AI agents: search, scrape, interact with the web, plus paper search.
A cross-platform desktop application for managing AI Agents and MCP Servers. 一款用于管理AI智能体与MCP服务器的跨平台桌面应用程序。
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