powerbi-modeling-mcp

powerbi-modeling-mcp

Power BI Modeling MCP Server provides AI agents with Power BI semantic modeling capabilities.

MCPDataOpen source
Type
MCP
Transport
stdio
Open source
Yes
GitHub Stars
★ 1.0k
Source
mcp-github

Overview

Power BI Modeling MCP Server brings Power BI semantic modeling capabilities to AI agents through a local MCP server. This enables developers and AI applications to interact with Power BI models in novel ways, such as using natural language to perform modeling changes or batch operations. The tool supports TMDL and Power BI project files, allowing AI agents to autonomously plan, create, and execute complex modeling tasks. Additionally, AI assistants can execute and validate DAX queries, helping test measures, troubleshoot calculation issues, and explore data.

Capabilities

  • Build and modify semantic models using natural language
  • Perform batch operations on large-scale objects
  • Apply modeling best practices
  • Support TMDL and Power BI project files
  • Execute and validate DAX queries

Use cases

Automate creation and updates of Power BI modelsBatch rename and refactor model objectsImplement modeling best practicesTest and validate DAX calculations

Setup

Requires: Node 环境API Key
Recommended installation via Visual Studio Code extension: 1. Install Visual Studio Code; 2. Install GitHub Copilot Chat extension; 3. Install Power BI Modeling MCP VS Code extension; 4. Confirm powerbi-modeling-mcp is available and select it in GitHub Copilot chat.

This information was compiled by AI from public sources and may contain inaccuracies — please refer to the source.

FAQ

How to manually install the MCP server?

You can install using NPX or by manually downloading the VSIX package.

What are the prerequisites?

Node.js environment and API Key are required.

Related skills