Power BI Authoring MCP Server (Local) — Claude Code MCP server
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.
claude mcp add power-bi-authoring-mcp-server-local -- npx -y @microsoft/powerbi-modeling-mcpWhat Power BI Authoring MCP Server (Local) 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.
What it helps with
- 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 for the agent
- 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.
How to install Power BI Authoring MCP Server (Local)
Platform CLI
claude mcp add power-bi-authoring-mcp-server-local -- npx -y @microsoft/powerbi-modeling-mcpPlatform CLI
codex mcp add power-bi-authoring-mcp-server-local -- npx -y @microsoft/powerbi-modeling-mcpConfig file
{
"mcpServers": {
"power-bi-authoring-mcp-server-local": {
"command": "npx",
"args": [
"-y",
"@microsoft/powerbi-modeling-mcp"
]
}
}
}Config file
{
"servers": {
"power-bi-authoring-mcp-server-local": {
"type": "stdio",
"command": "npx",
"args": [
"-y",
"@microsoft/powerbi-modeling-mcp"
]
}
}
}Platform CLI
gemini mcp add power-bi-authoring-mcp-server-local npx -y @microsoft/powerbi-modeling-mcpStep by step, with commands for each platform: How to add an MCP server to Claude Code, Codex, Cursor, VS Code, Gemini CLI and more
Questions about Power BI Authoring MCP Server (Local)
How do I install Power BI Authoring MCP Server (Local) in Claude Code?
Run claude mcp add power-bi-authoring-mcp-server-local -- npx -y @microsoft/powerbi-modeling-mcp in your terminal. Ensure Node.js is installed locally to execute npx.
What does Power BI Authoring MCP Server (Local) do?
It provides tools for AI agents to inspect and update Power BI semantic models. The server handles model structure, measures, TMDL projects, and DAX execution.
Can this server modify report visuals or page layouts?
No, the server operates strictly on semantic models. It cannot edit Power BI report pages, visuals, or diagram layouts.
