Power BI MCP Server

Example Use Cases

• 1

  Query and explore Power BI data models programmatically.

• 2

  Execute DAX queries and retrieve analytical results from Power BI Desktop.

• 3

  Access Power BI model metadata such as tables, columns, measures, and relationships.

Description

This MCP server allows Claude to query Power BI data models, execute DAX queries, and retrieve metadata such as tables, columns, measures, and relationships directly from Power BI Desktop without leaving the Claude interface. It automatically detects the Power BI XMLA port and connects locally using Windows security, providing seamless integration for enhanced data exploration and analysis. The server is Windows-only and read-only, designed for local Power BI Desktop instances.