Power BI Authoring MCP Server: Setup for Claude, Cursor and VS Code

• Connects to a Power BI model

  Opens a connection to a model in Power BI Desktop or a Fabric workspace. Every other tool works on the model you connect to first.

  Try: “Connect to Sales.pbix in Power BI Desktop.”

  Network · connection_operations

• Manages whole semantic models

  Lists, creates and updates semantic models, imports or exports them as TMDL folders, and deploys to Fabric.

  Try: “Export my open model to a TMDL folder and deploy it to the Finance workspace.”

  Write · database_operations

• Reads and edits model-level settings

  Gets model details and stats, renames or updates the model and refreshes it.

  Try: “Show me the size and stats of this model.”

  Write · model_operations

• Manages tables

  Gets, lists, creates, updates, renames, refreshes and deletes tables in the model.

  Try: “List all tables and rename "tbl_Sales" to "Sales".”

  Delete · table_operations

• Manages table columns

  Gets, lists, creates, updates, renames and deletes columns.

  Try: “Add a "Margin %" column to the Sales table.”

  Delete · column_operations

• Manages DAX measures

  Gets, lists, creates, updates, renames, moves and deletes measures, including their DAX code.

  Try: “Create a measure for year-to-date revenue in the Sales table.”

  Delete · measure_operations

• Manages table relationships

  Creates, updates, activates, deactivates, finds and deletes relationships between tables.

  Try: “Find tables with no relationship and connect Orders to Customers.”

  Delete · relationship_operations

• Runs and checks DAX queries

  Runs a DAX query against the connected model or validates it, which helps test measures and calculations.

  Try: “Run a DAX query that returns the top 10 products by revenue.”

  Network · dax_query_operations

• Groups edits so they can be undone

  Begins, commits or rolls back a transaction and reports its state, so a batch of edits applies as one.

  Try: “Start a transaction, apply the renames, then show me before you commit.”

  Write · transaction_operations

• Captures model engine events

  Starts and reads a trace of Analysis Services events, useful for seeing how a query or refresh behaves.

  Try: “Trace this query and tell me where the time goes.”

  Network · trace_operations

• Manages table partitions

  Creates, updates, deletes and refreshes individual partitions of a table.

  Try: “Refresh only the 2026 partition of the Sales table.”

  Delete · partition_operations

• Manages hierarchies

  Creates, updates and deletes user hierarchies and their levels, and reorders the levels.

  Try: “Create a Date hierarchy with Year, Quarter and Month.”

  Delete · user_hierarchy_operations

• Manages calculation groups

  Creates and edits calculation groups and their items, such as time intelligence variants.

  Try: “Turn my 6M and 12M average measures into a calculation group.”

  Delete · calculation_group_operations

• Manages security roles

  Configures roles and their row-level security table filters.

  Try: “Add a role that only sees rows for the user's own region.”

  Delete · security_role_operations

• Manages perspectives

  Creates and edits perspectives, which are focused views of the model for different audiences.

  Try: “Create a Finance perspective with only the finance tables.”

  Delete · perspective_operations

• Manages Power Query parameters

  Gets, lists, creates, updates, renames and deletes named expressions and Power Query parameters.

  Try: “Create a parameter that switches the data source folder.”

  Delete · named_expression_operations

• Manages DAX user-defined functions

  Creates, edits and deletes DAX user-defined functions in the model.

  Try: “Create a reusable function for safe division.”

  Delete · function_operations

• Manages languages

  Creates, updates and deletes cultures for multi-language models and lists valid culture names.

  Try: “Add French as a language to the model.”

  Delete · culture_operations

• Manages translations of model objects

  Reads and sets translated names and descriptions of tables, columns and measures in each culture.

  Try: “Translate all measure names and descriptions into French.”

  Write · object_translation_operations

• Manages calendar tables

  Creates and edits calendar objects and their time intelligence column groups.

  Try: “Mark the Date table as a calendar with year and month columns.”

  Delete · calendar_operations

• Manages Power Query groups

  Organises Power Query expressions into query groups.

  Try: “Group the staging queries into a folder called Staging.”

  Delete · query_group_operations

Watch out for

• It can delete tables, columns, measures and roles

  Most editing tools include a delete action. Use --readonly first, and back up the model before any change. github.com

• Model data can reach your AI provider

  Query results and model metadata go to the client and on to the model provider. Avoid sharing chat sessions that contain sensitive data. github.com

• It may send usage data to Microsoft

  The README says the software may collect information about your use and send it to Microsoft. Check the EULA before using it at work. github.com

• Extra connection hosts get your access token

  Hosts you add to PBI_MODELING_MCP_ALLOWED_CONNECTION_HOSTS receive your access token when it connects. Add only endpoints you trust. github.com

Security advisories