Connect Claude to your Power BI semantic models. Browse workspaces, tables, and measures, run DAX queries, and get results — with large datasets automatically saved to local CSV files to protect the LLM context window. Includes a query history log for cross-session reuse and auditability.
Overview
What it does
Ask your LLM to analyse Power BI data. The server connects to Power BI's REST API via OAuth device code flow, lets the agent explore your semantic models, and execute DAX queries — all running locally on your machine.
Key features
- 12 tools — authenticate, browse workspaces/datasets/tables/measures/columns, execute DAX, page through results, search query history, delete log entries
- Large result handling — queries returning >50 rows are auto-saved to a local CSV; the agent gets a compact summary and pages on demand
- Query history — every DAX execution is logged to a JSONL file with the user's intent, DAX, columns, and CSV path — searchable across sessions
- Secure — runs locally, tokens stored in OS-native secure storage (Keychain/DPAPI/LibSecret), no cloud relay
Quick start
Requires an Azure AD app registration with Dataset.Read.All and Workspace.Read.All permissions. See the README for a 5-minute setup guide.
Server Config
{
"mcpServers": {
"powerbi": {
"command": "uvx",
"args": [
"powerbi-analyst-mcp"
],
"env": {
"POWERBI_CLIENT_ID": "<YOUR_CLIENT_ID>",
"POWERBI_TENANT_ID": "<YOUR_TENANT_ID>"
}
}
}
}