Power BI Authoring MCP Server (Local)

{
  "mcpServers": {
    "power-bi-authoring-mcp-server-local": {
      "command": "npx",
      "args": [
        "-y",
        "@microsoft/powerbi-modeling-mcp"
      ]
    }
  }
}

claude mcp add --transport stdio power-bi-authoring-mcp-server-local -- npx -y @microsoft/powerbi-modeling-mcp

{
  "mcpServers": {
    "power-bi-authoring-mcp-server-local": {
      "type": "stdio",
      "command": "npx",
      "args": [
        "-y",
        "@microsoft/powerbi-modeling-mcp"
      ]
    }
  }
}

{
  "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).

• connection_operations

  Connect to Power BI Desktop or Fabric workspaces

• database_operations

  Manage semantic models - connect, create, update, list databases, import/export TMDL folders, deploy to Fabric

• transaction_operations

  Control database transactions (begin, commit, rollback, get status)

• model_operations

  Work with the overall model (get, create, update, refresh, get stats, rename)

• table_operations

  Manage tables (create, update, delete, get, list, refresh, rename)

• column_operations

  Manage individual table columns (create, update, delete, get, list, rename)

• measure_operations

  Manage individual DAX measures (create, update, delete, get, list, rename, move between tables)

• relationship_operations

  Handle relationships between tables (create, update, delete, activate/deactivate, find)

• dax_query_operations

  Execute and validate DAX queries against the model

• trace_operations

  Perform trace operations on semantic model to capture and analyze Analysis Services events.

• partition_operations

  Manage table partitions (create, update, delete, refresh specific partitions)

• user_hierarchy_operations

  Work with user-defined hierarchies (create, update, delete levels, reorder)

• calculation_group_operations

  Manage calculation groups and calculation items for time intelligence and other calculations

• security_role_operations

  Configure security roles and row-level security (RLS) table permissions

• perspective_operations

  Manage perspectives and their members (filtered views of the model for different audiences)

• named_expression_operations

  Work with named expressions and Power Query parameters (create, update, delete, get, list, rename)

• function_operations

  Manage individual DAX user-defined functions

• culture_operations

  Manage cultures for multi-language support (create, update, delete, get valid culture names)

• object_translation_operations

  Handle translations for model objects across different cultures/languages

• calendar_operations

  Manage calendar objects and time intelligence column groups

• query_group_operations

  Organize and manage query groups for Power Query expressions

The Power BI Authoring MCP Server implements the MCP specification to create a seamless connection between AI agents and Power BI semantic models.