Power BI Authoring MCP

The Power BI Authoring MCP Server lets your agent work on Power BI semantic models in plain words. It connects to models in Power BI Desktop, in a Fabric workspace or in Power BI Project (PBIP and TMDL) files. What you can do with it - Create and change tables, columns, measures, relationships, hierarchies and partitions - Make bulk changes across many objects at once, such as renames and refactors, inside transactions you can roll back - Run and validate DAX queries, and benchmark a query against more than one model - Add descriptions and translations across the model, and set up row-level security roles - Refactor measures into calculation groups or DAX user-defined functions - Document a model as Markdown and check it against modeling best practices How it connects It runs on your machine with npx @microsoft/powerbi-modeling-mcp@latest --start, or through its VS Code extension with GitHub Copilot. Before first use you accept its license (EULA); the server blocks its other tools until you do. For models in a Fabric workspace, Microsoft recommends its hosted Power BI Authoring MCP server instead. Good to know Back up your model before making changes, since the agent may make edits you didn't expect. It only changes the semantic model, not report pages or diagram layouts.