Power Bi Analyst Mcp
@mbrummerstedt
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 audi
Overview
What is Power Bi Analyst Mcp?
Power Bi Analyst Mcp enables LLMs to analyze Power BI data by connecting to the Power BI REST API via OAuth device code flow. It runs locally on your machine, allowing an agent to explore semantic models and execute DAX queries. The server provides 12 tools for authentication, browsing workspaces/datasets/tables/measures/columns, executing DAX, paginating results, searching query history, and deleting log entries.
How to use Power Bi Analyst Mcp?
You need an Azure AD app registration with Dataset.Read.All and Workspace.Read.All permissions. A 5-minute setup guide is available in the README. After configuration, run the server locally; the LLM can then invoke the provided tools to interact with your Power BI environment.
Use cases of Power Bi Analyst Mcp
- Ask an LLM to analyze Power BI semantic models and datasets.
- Execute and iterate DAX queries with automatic pagination of large results.
- Browse workspaces, datasets, tables, measures, and columns through natural language.
- Search and review query history across sessions for auditing or reproducibility.
- Delete specific log entries from the query history.
FAQ from Power Bi Analyst Mcp
How does Power Bi Analyst Mcp handle large query results?
Queries returning more than 50 rows are automatically saved to a local CSV file. The agent receives a compact summary and can page through the results on demand.
Where is my data stored and is it secure?
All tokens are stored in OS-native secure storage (Keychain on macOS, DPAPI on Windows, LibSecret on Linux). Queries and logs are written to a local JSONL file; no data is relayed through a cloud service.
What dependencies or runtime are required?
The server depends on an Azure AD app registration with the appropriate Power BI permissions. The README provides a 5-minute setup for this registration.
What authentication transport is used?
Authentication uses the OAuth device code flow, which allows the user to sign in via a browser without exposing credentials directly to the tool.
Does the server support query history?
Yes, every DAX execution is logged to a JSONL file containing the user’s intent, the DAX query, output columns, and the CSV file path. The history is searchable across sessions.
