FreelexHo/power-bi-mcp

What it does

FreelexHo/power-bi-mcp is an MCP (Model Context Protocol) server that integrates Power BI capabilities with AI assistants like Claude. It enables users to authenticate via device code, execute DAX queries with Row-Level Security (RLS) simulation, trigger table-level refreshes with retry logic, locate PBIP source files, and generate scheduled refresh diagnostic reports with root cause error analysis.

How to set up

Installation requires Python 3.x and the MCP SDK. Clone the repository from GitHub, install dependencies via pip, configure Power BI authentication using device code flow, and add the server configuration to your MCP client. Detailed setup instructions are available in the repository's README file.

Key features

• Device code authentication for secure Power BI access
• DAX query execution with RLS simulation capabilities
• Table-level refresh polling with automatic retry mechanisms
• Refresh diagnostics with root cause error catalog
• PBIP source file location and tracking
• Scheduled refresh reports and monitoring
• Cross-platform support (Windows, macOS, Linux)