PowerBI MCP Server
Connects Claude to Microsoft PowerBI through the REST API using Azure AD service principal authentication. Exposes tools to list workspaces and datasets, fetch schema information including tables and columns, check refresh status and parameters, and execute DAX queries directly against your data models. Useful when you need to query PowerBI data conversationally without opening the web interface, explore available datasets across your organization, or build natural language workflows on top of existing PowerBI infrastructure. Requires setting up an Azure AD app registration and granting it workspace access with Admin, Member, or Contributor permissions.
- tools
- 7
- auth
- Secret needed
- transport
- STDIO
- env vars
- 3
- last updated
- Feb 5, 2026
Tools
7 toolsPublic tool metadata for what this MCP can expose to an agent.
get_workspacesList PowerBI workspaces accessible to the service principal.
List PowerBI workspaces accessible to the service principal.
No parameter schema in public metadata yet.
get_datasetsGet list of datasets from a workspace or "My workspace".
Get list of datasets from a workspace or "My workspace".
No parameter schema in public metadata yet.
get_datasetGet detailed information about a specific dataset including schema and tables.
Get detailed information about a specific dataset including schema and tables.
No parameter schema in public metadata yet.
get_reportsList PowerBI reports in a workspace.
List PowerBI reports in a workspace.
No parameter schema in public metadata yet.
get_refresh_historyGet refresh history for a dataset showing recent refresh operations.
Get refresh history for a dataset showing recent refresh operations.
No parameter schema in public metadata yet.
get_parametersGet parameters defined in a dataset.
Get parameters defined in a dataset.
No parameter schema in public metadata yet.
query_datasetExecute DAX queries against a dataset.
Execute DAX queries against a dataset.
No parameter schema in public metadata yet.
Sponsors
Agent CaffeineSponsoredClose your lid, come back to finished work
SnugSponsoredThe clipboard manager for the AI eraPromote your product hereReach 125k+ visitors monthly
WaxSponsoredBlock anything with supervision, without erasing your iPhonePromote your product hereReach 125k+ visitors monthly
knobsSponsoredSee your site on any phone, any day, in any languageConfiguration
POWERBI_TENANT_ID*Azure AD Tenant ID for PowerBI authentication
POWERBI_CLIENT_ID*Azure AD Application (Client) ID with PowerBI API access
POWERBI_CLIENT_SECRET*secretAzure AD Client Secret for service principal authentication
Readme
PowerBI MCP Server
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
✨ Features
Details
- Repository
- github.com/gurvinder-dhillon/powerbi-mcp
- Category
- Data & Analytics
- Package
powerbi-mcp- Transport
- STDIO
- Auth
- Required
- Registry
- MCP registry, active
Related Data & Analytics MCP servers
View all
Monte Carloio.github.monte-carlo-data/mcpData + AI observability — monitor and troubleshoot production-grade agents and the context they use.0stars
Csv Tools Mcpmukundakatta/mcp-stackReliable CSV parsing + generation. Handles quotes, embedded commas, BOMs, CRLF.0stars
Power BI Authoring MCP Server (Local)microsoft/powerbi-modeling-mcpThe Power BI Authoring MCP server lets an AI agent create and change Power BI semantic models.1.3Kstars
TickDB Market Datatickdb/tickdb-unified-realtime-marketdata-apiReal-time & historical market data: forex, stocks, crypto, indices, metals, K-line, quotes0stars
NY Data Registrybetanyc/ny-data-registry-mcpFind New York open data: which portal covers a place or topic, how to query it, datasets and columns11stars