# Power BI Authoring MCP Server (Local) (MCP server)

> Power BI Authoring MCP Server (Local) is an MCP server that lets an AI agent create and change Power BI semantic models. It has 1,202 GitHub stars, is released under the MIT license and runs locally with npx -y @microsoft/powerbi-modeling-mcp.

The Power BI Authoring MCP Server implements the MCP specification to create a seamless connection between AI agents and Power BI semantic models.

## Key facts

| Fact | Value |
|---|---|
| Repository | https://github.com/microsoft/powerbi-modeling-mcp |
| GitHub stars | 1,202 |
| License | MIT |
| Language | Unknown |
| Transport | stdio |
| Packages | npm: @microsoft/powerbi-modeling-mcp |
| Remote URL | none |
| Needs API key | no |
| Official | yes |
| Works with | Claude Desktop, Claude Code, Cursor, VS Code |
| Category | Data & analytics |
| Latest release | v1.0.0 (Sep 25, 2026) |
| Last commit | Sep 29, 2026 |
| MCP registry name | com.microsoft/powerbi-modeling-mcp |

## Install

### Claude Desktop (claude_desktop_config.json)

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

Settings > Developer > Edit Config. macOS: ~/Library/Application Support/Claude/, Windows: %APPDATA%\Claude\. Restart Claude Desktop afterwards.

### Claude Code

```sh
claude mcp add --transport stdio power-bi-authoring-mcp-server-local -- npx -y @microsoft/powerbi-modeling-mcp
```

### Cursor (.cursor/mcp.json)

```json
{
  "mcpServers": {
    "power-bi-authoring-mcp-server-local": {
      "type": "stdio",
      "command": "npx",
      "args": [
        "-y",
        "@microsoft/powerbi-modeling-mcp"
      ]
    }
  }
}
```

Project file; use ~/.cursor/mcp.json to enable it in every project.

### VS Code (.vscode/mcp.json)

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

Config formats checked against the official docs on 2026-10-07.

## Tools

- `connection_operations`: Connect to Power BI Desktop or Fabric workspaces
- `database_operations`: Manage semantic models - connect, create, update, list databases, import/export TMDL folders, deploy to Fabric
- `transaction_operations`: Control database transactions (begin, commit, rollback, get status)
- `model_operations`: Work with the overall model (get, create, update, refresh, get stats, rename)
- `table_operations`: Manage tables (create, update, delete, get, list, refresh, rename)
- `column_operations`: Manage individual table columns (create, update, delete, get, list, rename)
- `measure_operations`: Manage individual DAX measures (create, update, delete, get, list, rename, move between tables)
- `relationship_operations`: Handle relationships between tables (create, update, delete, activate/deactivate, find)
- `dax_query_operations`: Execute and validate DAX queries against the model
- `trace_operations`: Perform trace operations on semantic model to capture and analyze Analysis Services events.
- `partition_operations`: Manage table partitions (create, update, delete, refresh specific partitions)
- `user_hierarchy_operations`: Work with user-defined hierarchies (create, update, delete levels, reorder)
- `calculation_group_operations`: Manage calculation groups and calculation items for time intelligence and other calculations
- `security_role_operations`: Configure security roles and row-level security (RLS) table permissions
- `perspective_operations`: Manage perspectives and their members (filtered views of the model for different audiences)
- `named_expression_operations`: Work with named expressions and Power Query parameters (create, update, delete, get, list, rename)
- `function_operations`: Manage individual DAX user-defined functions
- `culture_operations`: Manage cultures for multi-language support (create, update, delete, get valid culture names)
- `object_translation_operations`: Handle translations for model objects across different cultures/languages
- `calendar_operations`: Manage calendar objects and time intelligence column groups
- `query_group_operations`: Organize and manage query groups for Power Query expressions

## Similar MCP servers

- [Ida Pro MCP](https://appsgit.com/mcp-servers/ida-pro-mcp): AI-powered reverse engineering assistant that bridges IDA Pro with language models through MCP. (12,497 stars, MIT)
- [Ask Jev](https://appsgit.com/mcp-servers/ask-jev): Evaluate state with typed choice, score, and probability questions. (5,174 stars, MIT, needs API key)
- [Jitsu](https://appsgit.com/mcp-servers/jitsu): Manage Jitsu data pipelines: destinations, streams, connections, functions, live events. (5,101 stars, MIT, official)
- [Google Ads + Meta Ads + SEO/GEO MCP](https://appsgit.com/mcp-servers/google-ads-meta-ads-seo-geo-mcp): Google Ads, Meta Ads, SEO, GEO & GA4 MCP by Ryze AI - audits, reports, keywords, Search Console. (4,107 stars, MIT)
- [Blitz](https://appsgit.com/mcp-servers/blitz): Give AI agents full control over iOS/macOS development via a native macOS app with 30+ MCP tools. (1,754 stars, Apache-2.0)
- [Chunkhound](https://appsgit.com/mcp-servers/chunkhound): Your entire engineering context, deeply understood. (1,445 stars, MIT, official)

---

Canonical page: https://appsgit.com/mcp-servers/power-bi-authoring-mcp-server-local
Source: appsgit (https://appsgit.com), the app store for github. Data from the GitHub API, refreshed nightly.
Machine access: JSON API https://appsgit.com/api/v1/apps (OpenAPI: https://appsgit.com/openapi.json), MCP server https://mcp.appsgit.com/mcp, full index https://appsgit.com/llms-full.txt.