powerbi-modeling-mcp

Level ALocal

The Power BI Modeling MCP Server, brings Power BI semantic modeling capabilities to your AI agents.

Overview

Power BI Authoring MCP Server is a local MCP server from Microsoft that connects AI agents to Power BI semantic models. Users can create and modify tables, columns, measures, and relationships in natural language, run bulk operations such as renaming, refactoring, translations, and security rules across hundreds of objects with transaction support, apply modeling best practices, work with TMDL and Power BI Project files, and execute and validate DAX queries.

⭐ 1.3kDevelopment ToolsRepo ↗Updated 2026-11-19

Installation

MCP client config (paste into mcp.json)

{
  "mcpServers": {
    "powerbi-modeling-mcp": {
      "command": "npx",
      "args": [
        "-y",
        "@microsoft/powerbi-modeling-mcp@latest"
      ]
    }
  }
}

Agent install prompt

Copy and paste into Cursor / Claude / other agents to install this MCP for you

Please read this MCP repository and install it into my current environment:
https://github.com/microsoft/powerbi-modeling-mcp

Known working client config (can write into mcp.json):
{
  "mcpServers": {
    "powerbi-modeling-mcp": {
      "command": "npx",
      "args": [
        "-y",
        "@microsoft/powerbi-modeling-mcp@latest"
      ]
    }
  }
}

Please: 1) check README for deps and env vars; 2) write config for my client; 3) if secrets are missing, tell me what to fill — do not invent values.

Related servers