Power BI Authoring MCP Server (Local)
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,292 GitHub stars, is released under the MIT license and runs locally with npx -y @microsoft/powerbi-modeling-mcp.
github.com/microsoft/powerbi-modeling-mcp (opens in a new tab)
Data as of from the GitHub API and the official MCP registry; description from the project's repository. Report an error
Install Power BI Authoring MCP Server (Local)
Generated from the server's MCP registry entry. Replace your-value with your own values.
Claude Desktop
{
"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
claude mcp add --transport stdio power-bi-authoring-mcp-server-local -- npx -y @microsoft/powerbi-modeling-mcpCursor
{
"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
{
"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 Oct 7, 2026: modelcontextprotocol.io (opens in a new tab), code.claude.com (opens in a new tab), cursor.com (opens in a new tab), code.visualstudio.com (opens in a new tab).
Tools (21)
Parsed from the Tools section of the README; check the repository for the current list.
connection_operationsConnect to Power BI Desktop or Fabric workspaces
database_operationsManage semantic models - connect, create, update, list databases, import/export TMDL folders, deploy to Fabric
transaction_operationsControl database transactions (begin, commit, rollback, get status)
model_operationsWork with the overall model (get, create, update, refresh, get stats, rename)
table_operationsManage tables (create, update, delete, get, list, refresh, rename)
column_operationsManage individual table columns (create, update, delete, get, list, rename)
measure_operationsManage individual DAX measures (create, update, delete, get, list, rename, move between tables)
relationship_operationsHandle relationships between tables (create, update, delete, activate/deactivate, find)
dax_query_operationsExecute and validate DAX queries against the model
trace_operationsPerform trace operations on semantic model to capture and analyze Analysis Services events.
partition_operationsManage table partitions (create, update, delete, refresh specific partitions)
user_hierarchy_operationsWork with user-defined hierarchies (create, update, delete levels, reorder)
calculation_group_operationsManage calculation groups and calculation items for time intelligence and other calculations
security_role_operationsConfigure security roles and row-level security (RLS) table permissions
perspective_operationsManage perspectives and their members (filtered views of the model for different audiences)
named_expression_operationsWork with named expressions and Power Query parameters (create, update, delete, get, list, rename)
function_operationsManage individual DAX user-defined functions
culture_operationsManage cultures for multi-language support (create, update, delete, get valid culture names)
object_translation_operationsHandle translations for model objects across different cultures/languages
calendar_operationsManage calendar objects and time intelligence column groups
query_group_operationsOrganize and manage query groups for Power Query expressions
About Power BI Authoring MCP Server (Local)
The Power BI Authoring MCP Server implements the MCP specification to create a seamless connection between AI agents and Power BI semantic models.
Similar MCP servers
More data & analytics MCP servers
Jupyter MCP Server
datalayer/jupyter-mcp-server
🪐 🔧 Model Context Protocol (MCP) Server for Jupyter.
Active · last commit Nov 14, 2026
Data & analyticsPythonClickHouse
ClickHouse/mcp-clickhouse
Official ClickHouse MCP server for querying and exploring ClickHouse clusters and chDB.
Active · last commit Nov 13, 2026
OfficialData & analyticsPythonChunkhound
chunkhound/chunkhound
Your entire engineering context, deeply understood.
Active · last commit Nov 15, 2026
OfficialData & analyticsPythonOpenanalytics
OpenLabs-so/openanalytics
Open-source, privacy-first and cookieless web analytics with revenue attribution and an MCP server.
Active · last commit Oct 22, 2026
Data & analyticsTypeScriptJitsu
jitsucom/jitsu
Manage Jitsu data pipelines: destinations, streams, connections, functions, live events.
Active · last commit Nov 16, 2026
OfficialData & analyticsTypeScriptDbt MCP
dbt-labs/dbt-mcp
A MCP (Model Context Protocol) server for interacting with dbt.
Active · last commit Nov 13, 2026
OfficialData & analyticsPython
How do I install the Power BI Authoring MCP Server (Local) MCP server?
Add the command npx -y @microsoft/powerbi-modeling-mcp to your MCP client: put it in claude_desktop_config.json for Claude Desktop, run claude mcp add for Claude Code, or add it to .cursor/mcp.json (Cursor) or .vscode/mcp.json (VS Code). The snippets on this page are ready to paste.
Is Power BI Authoring MCP Server (Local) free?
The server is open source under the MIT license, so running it is free. It does not declare any required API key.
Is Power BI Authoring MCP Server (Local) actively maintained?
The most recent commit was on Nov 13, 2026. The latest release is v1.0.1, published Nov 6, 2026. appsgit only lists MCP servers with a commit in the last six months.