---
title: "Power BI Authoring MCP Server: review, setup & limitations · Undominated.ai"
canonical: https://undominated.ai/mcp-servers/microsoft-powerbi-modeling-mcp/
description: "Local stdio server that queries and edits Power BI semantic models in Power BI Desktop, Fabric workspaces or PBIP folders. It writes by default; --readonly prevents write operations."
---

# Power BI Authoring MCP Server: review, setup & limitations · Undominated.ai

> Local stdio server that queries and edits Power BI semantic models in Power BI Desktop, Fabric workspaces or PBIP folders. It writes by default; --readonly prevents write operations.

[← Explore all mcp servers](/mcp-servers/)

DATA AND ANALYTICS / Microsoft

# Power BI Authoring MCP Server

Local stdio server that queries and edits Power BI semantic models in Power BI Desktop, Fabric workspaces or PBIP folders. It writes by default; --readonly prevents write operations.

 [See setup guidance ↓](#setup)[Original source ↗](https://github.com/microsoft/powerbi-modeling-mcp)

SOURCE REVIEW

 Reviewed 2026-10-13
 Evidence 3 linked sources
 Publisher Microsoft
 Licence [Microsoft EULA for the software; MIT text in the repository LICENSE ↗](https://github.com/microsoft/powerbi-modeling-mcp/blob/2b25defb975169ffb573195cc0ff8006835b8a6e/EULA.txt)
 Revision 2b25defb9751
 [Read what was—and wasn’t—checked ↓](#review)

“It cannot modify other types of Power BI metadata, such as report pages or semantic model elements like diagram layouts.”

 [Microsoft · upstream description ↗](https://github.com/microsoft/powerbi-modeling-mcp/blob/2b25defb975169ffb573195cc0ff8006835b8a6e/README.md) Our analysis follows below.

01 / THE REASONING

## Why this made the selection.

 - The README's settings table documents --readonly, a safe mode that prevents any write operations to the semantic model, and says the default --readwrite asks for confirmation before applying an edit, once per database.
- The README's tools table lists 21 tools by name (its text also describes an accept_eula tool) and documents interactive or service-principal authentication and a host allowlist (PBI_MODELING_MCP_ALLOWED_CONNECTION_HOSTS) for non-Power BI XMLA endpoints.

### A good fit for

 - Inspecting semantic-model metadata and querying DAX in read-only mode
- Reviewing a model before separately authorizing model changes

### Weigh up before choosing

 - The repository's LICENSE is the MIT text, but the README's License section says use of the software is subject to the Power BI Authoring MCP Server EULA (EULA.txt), whose scope-of-licence clause forbids sharing, publishing or distributing the software. The repository holds no server source.
- The npm package blocks all other tool calls until the EULA is accepted, through the accept_eula tool, --accepteula or PBI_MODELING_MCP_ACCEPT_EULA=true.
- The README lists Write permission on the semantic model as a requirement. The default --readwrite mode can create, update, delete, refresh and rename model objects and deploy to Fabric.
- The README says data the server retrieves is sent to the MCP client and may be forwarded to the LLM provider, and that the software may send usage data to Microsoft.
- For Fabric workspaces the README recommends Microsoft's remote Power BI Authoring MCP server instead of this local one. The README's npx launch uses @latest and is not pinned by this revision.

02 / THE REVIEW RECORD

## What we actually inspected.

Source review has boundaries. A clear record is more useful than a “safe” badge.

### Material inspected

 - README.md at 2b25defb975169ffb573195cc0ff8006835b8a6e: installation, EULA acceptance, tools, prompts, settings, limitations, licence and data-privacy sections
- LICENSE at the same commit: MIT, Copyright (c) Microsoft Corporation
- EULA.txt at the same commit: Microsoft Software License Terms, scope of licence
- Repository root listing at the same commit: no package.json and no server source

### Our findings

 - --start is required to start the MCP server.
- --readonly is documented; default --readwrite includes a confirmation prompt once per database.
- npm tooling blocks other calls until explicit EULA acceptance. In an interactive session the agent can call accept_eula after the user authorizes it, and the acceptance is saved locally.
- README states semantic-model Write permission is required; the read-only switch does not establish a weaker account permission requirement.
- README and LICENSE disagree: LICENSE is MIT, while the README says use of the software is subject to EULA.txt, which forbids distributing the software. This record therefore sets redistribution to false; it previously said MIT with redistribution.
- The README lists 21 tools: connection, database, transaction, model, table, column, measure, relationship, dax_query, trace, partition, user_hierarchy, calculation_group, security_role, perspective, named_expression, function, culture, object_translation, calendar and query_group operations.
- Authentication is --authmode interactive (default) or serviceprincipal, using AZURE_CLIENT_ID, AZURE_TENANT_ID and a client secret or certificate. The README says the server sends access tokens to the hosts it connects to.
- The repository contains no package.json or source, so no implementation language is recorded; the previous JavaScript entry was not supported by a file. The README distributes the server as the npm package and as powerbi-modeling-mcp.exe inside a VSIX.
- configExample is the README's npx block at this commit, which has no client wrapper key. The README gives no one-line shell command, so install.command is null; the previous command and configExample added --readonly, which the README block does not contain.
- Health on 2026-10-13: repository not archived, default-branch HEAD was this commit, GitHub reports MIT.

### Not established by this review

 - The pinned documentation and selected source files were reviewed; the external server was not executed by this review.
- No authenticated service requests, account mutations, tenant access controls, or end-to-end MCP client setup were tested.
- A repository revision does not pin an unversioned or @latest registry package; resolved package provenance and runtime permission enforcement remain unverified.

The review applies to the material and revision named here. A newer upstream release can change its behavior.

03 / PUT IT TO WORK

## Connect a server deliberately.

[Upstream setup instructions ↗](https://github.com/microsoft/powerbi-modeling-mcp/blob/2b25defb975169ffb573195cc0ff8006835b8a6e/README.md)
 - The README gives no one-line shell command. Add its npx block (args -y, @microsoft/powerbi-modeling-mcp@latest, --start) to the client, or install the VS Code extension.
- Add --readonly to args for inspection only; the README documents it as the mode that prevents any write operations.
- Review EULA.txt and accept it through the server only if you agree.
- Connect to the intended Desktop file, Fabric workspace or PBIP folder with Write permission on the model.

### Before you start

 - Node.js
- Explicit acceptance of the Power BI Authoring MCP Server EULA
- Write permission on the semantic model

### Documented configuration example

Use the client and authentication context described in the setup guidance. Configuration formats vary between hosts.

 {
 "powerbi-authoring-local": {
 "type": "stdio",
 "command": "npx",
 "args": [
 "-y",
 "@microsoft/powerbi-modeling-mcp@latest",
 "--start"
 ]
 }
} Copy configuration ↗

### Compatibility

Local stdio MCP clients; the README recommends VS Code with GitHub Copilot and the Power BI Authoring MCP extension · Semantic models in Power BI Desktop, a Fabric workspace or Power BI Project (PBIP) files; --compatibility Full for Analysis Services databases

### Transports

stdio

### Local process, model credentials and explicit EULA

 - Authenticates interactively by default or as a Microsoft Entra service principal; credentials go through the Azure Identity SDK.
- In --readonly mode, reads model metadata and runs DAX queries.
- In the default --readwrite mode, creates, updates, deletes, refreshes and renames model objects, changes security roles and deploys to Fabric, after a confirmation once per database.
- Sends retrieved model data to the MCP client and possibly its LLM provider; may send usage data to Microsoft.

### Cost model

Use is governed by the Power BI Authoring MCP Server EULA. Power BI/Fabric licensing and capacity charges are separate; none was reviewed.

04 / FOLLOW THE EVIDENCE

## The source trail.

Our notes are separate from the original resource. Check upstream before adopting a new version.

 - [Server documentation ↗](https://github.com/microsoft/powerbi-modeling-mcp/blob/2b25defb975169ffb573195cc0ff8006835b8a6e/README.md) Checked 2026-10-13 https://github.com/microsoft/powerbi-modeling-mcp/blob/2b25defb975169ffb573195cc0ff8006835b8a6e/README.md Supports: upstreamDescription, configExample, tools, settings, limitations, access, transports
- [Software licence terms (EULA) ↗](https://github.com/microsoft/powerbi-modeling-mcp/blob/2b25defb975169ffb573195cc0ff8006835b8a6e/EULA.txt) Checked 2026-10-13 https://github.com/microsoft/powerbi-modeling-mcp/blob/2b25defb975169ffb573195cc0ff8006835b8a6e/EULA.txt Supports: license, no distribution of the software
- [Repository licence ↗](https://github.com/microsoft/powerbi-modeling-mcp/blob/2b25defb975169ffb573195cc0ff8006835b8a6e/LICENSE) Checked 2026-10-13 https://github.com/microsoft/powerbi-modeling-mcp/blob/2b25defb975169ffb573195cc0ff8006835b8a6e/LICENSE Supports: MIT text for the repository

KEEP COMPARING

## Other approaches to consider.

Related by category or shared topics. These are alternatives to inspect, not a measured quality order.

 [### Confluent MCP Server ↗ Covers Kafka and Confluent Cloud, a streaming gap next to the database servers already listed.](/mcp-servers/confluent-mcp-confluent/)[### Prefect MCP ↗ Inspects Prefect flow runs, deployments and logs with an optional proxy to current Prefect documentation.](/mcp-servers/prefect/)

 [AI Tools ↗](/tools/)[Skills ↗](/skills/)[Agents ↗](/agents/)[MCP Servers ↗](/mcp-servers/)[Workflows ↗](/workflows/)

## Continue your investigation

 - [Inspect resource evidence](/tools/)
- [Choose a host](/agents/)
- [Inspect reusable workflows](/skills/)
- [Use Undominated data](/api/)
