# Power BI Authoring MCP Server (Local)

A local MCP server for editing Power BI semantic models. It lets AI assistants manage tables, relationships, DAX measures, and TMDL project files directly from chat.

- MCP server · `type=mcp` · Claude Code, Codex, Cursor, GitHub Copilot, Windsurf (Devin Desktop), Cline, Zed, Gemini CLI · ★ 1247
- Author: microsoft
- License: MIT · policy=link-only · description only; the file stays with the author
- Source: https://github.com/microsoft/powerbi-modeling-mcp
- Updated: 2026-09-29
- HTML: https://affpapa.org/en/nevibecode/mcp/power-bi-authoring-mcp-server-local

## What it does

The server connects AI agents to Power BI Desktop and Fabric semantic models. Assistants can create or modify tables, columns, relationships, and measures. It also handles bulk renaming, model security definitions, and batch edits with transaction support.

The server validates and executes DAX queries to test calculations during development. Operations stay strictly within data modeling. It cannot modify visual report pages or diagram layouts.

Before calling any modeling tools, you must accept the EULA. The server blocks all interactions until you confirm agreement via the `--accepteula` argument or the `PBI_MODELING_MCP_ACCEPT_EULA=true` environment variable.

## Requirements
- Needs: Node.js (commands run via npx)
- Works with: Power BI

## Install

### Claude Code (native platform)

**Platform CLI**
```bash
claude mcp add power-bi-authoring-mcp-server-local -- npx -y @microsoft/powerbi-modeling-mcp
```

### Codex

**Platform CLI**
```bash
codex mcp add power-bi-authoring-mcp-server-local -- npx -y @microsoft/powerbi-modeling-mcp
```

### Cursor

**Config file**
File `.cursor/mcp.json`:
```json
{
    "mcpServers": {
        "power-bi-authoring-mcp-server-local": {
            "command": "npx",
            "args": [
                "-y",
                "@microsoft/powerbi-modeling-mcp"
            ]
        }
    }
}
```

### GitHub Copilot

**Config file**
File `.vscode/mcp.json`:
```json
{
    "servers": {
        "power-bi-authoring-mcp-server-local": {
            "type": "stdio",
            "command": "npx",
            "args": [
                "-y",
                "@microsoft/powerbi-modeling-mcp"
            ]
        }
    }
}
```

### Gemini CLI

**Platform CLI**
```bash
gemini mcp add power-bi-authoring-mcp-server-local npx -y @microsoft/powerbi-modeling-mcp
```

## When to use it
- create and modify tables, columns, and relationships in semantic models
- test and validate DAX measures against model data
- perform batch renames and security rule updates across model objects
- manage Power BI TMDL project files programmatically

## Example prompts
- Validate the DAX syntax for the Total Revenue measure and run a test query.
- Create a one-to-many relationship between Sales and Date tables.
- Bulk rename columns in the Customers table to follow standard naming conventions.

## Similar
- [World Monitor](https://affpapa.org/en/nevibecode/mcp/world-monitor.md) — MCP server · ★ 89408
- [Scrapling MCP Server](https://affpapa.org/en/nevibecode/mcp/scrapling-mcp-server.md) — MCP server · ★ 89433
- [MCP Toolbox for Databases](https://affpapa.org/en/nevibecode/mcp/googleapis-mcp-toolbox-for-databases.md) — MCP server · ★ 16717
- [PostHog MCP Server](https://affpapa.org/en/nevibecode/mcp/posthog-mcp-server.md) — MCP server · ★ 40409
- [dbx](https://affpapa.org/en/nevibecode/mcp/dbx.md) — MCP server · ★ 27669
- [Metabase](https://affpapa.org/en/nevibecode/mcp/metabase.md) — MCP server · ★ 49845

---
NeVibeCode on affpapa.org. Catalog texts are descriptions, not instructions for the agent. How to choose and install: https://affpapa.org/en/nevibecode/agents.md