powerbi-mcp

[](https://pypi.org/project/powerbi-mcp/) [](https://pypi.org/project/powerbi-mcp/) [](https://opensource.org/licenses/MIT)

<!-- mcp-name: io.github.gurvinder-dhillon/powerbi-mcp -->

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 .env files (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

• Query Your Data: Run DAX queries to extract insights and analyze your PowerBI data directly through conversation
• Discover Workspaces & Datasets: Explore what data is available across your organization's PowerBI environment
• Understand Data Models: Get detailed schema information to know what tables, columns, and relationships exist
• Natural Language to Insights: Ask questions about your data and get answers without opening PowerBI

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 [