powerbi-mcp

概述

Power BI MCP Server 通过模型上下文协议将 AI 助手与 Microsoft Power BI 连接起来。它为查询数据、管理模型和执行批量操作提供了统一接口，支持本地 .pbix 文件和云托管数据集。该服务器具有高级安全功能，包括 PII 检测、审计日志记录和可配置的访问策略。其突出功能是 PBIP 连接器，它能够安全地重构操作，同时更新语义模型和报表可视化，防止重命名表格导致报表引用中断的常见问题。

试试问 AI

装完之后，这里有 5 个你可以让 AI 做的事：

• desktop_discover_instances

  Auto-discover running Power BI Desktop instances

  试试:Find all running Power BI Desktop instances试试:List available Power BI Desktop connections
• desktop_connect

  Connect to a specific Power BI Desktop instance with optional RLS role

  试试:Connect to my Power BI Desktop instance试试:Connect to Power BI with Sales role
• desktop_execute_dax

  Execute DAX queries against Power BI Desktop model with security processing

  试试:Calculate total sales last year试试:Show top 10 customers by revenue
• list_workspaces

  List accessible Power BI Service workspaces

  试试:Show my Power BI workspaces试试:List all available workspaces
• list_datasets

  List datasets in a specified Power BI workspace

  试试:List datasets in Sales workspace试试:What datasets are in Finance workspace?
• execute_dax

  Execute DAX queries against Power BI Service datasets

  试试:Show monthly revenue trends试试:Calculate product profit margin
• desktop_list_rls_roles

  List Row-Level Security roles defined in the model

  试试:Show all RLS roles试试:List security roles in model
• desktop_set_rls_role

  Activate a specific RLS role for testing data access

  试试:Enable Sales role for testing试试:Set RLS role to Manager
• scan_table_dependencies

  Analyze dependencies before renaming tables/columns/measures

  试试:Check what depends on Sales table试试:Show impact of renaming Customer column
• batch_update_measures

  Bulk update measure expressions in the model

  试试:Update all margin calculations试试:Change all sales measures to use new category
• pbip_rename_tables

  Safely rename tables in PBIP projects (updates model + visuals + DAX)

  试试:Rename Customers table to Accounts试试:Change Orders to SalesOrders
• pbip_load_project

  Load a PBIP project for editing operations

  试试:Load Sales Report project试试:Open Finance PBIP file

可对比工具

安装

# 通过 pip 安装
pip install powerbi-mcp

# 配置 Claude Desktop
{
  "mcpServers": {
    "powerbi": {
      "command": "python",
      "args": ["-m", "powerbi_mcp"],
      "env": {
        "POWERBI_MCP_WORKSPACE": "your_workspace_path"
      }
    }
  }
}

FAQ

这个服务器能否同时支持 Power BI Desktop 和 Power BI Service？

是的，该服务器支持双重连接 - 它可以与本地 Power BI Desktop 实例和通过 XMLA 端点连接的云托管 Power BI Service 进行交互。

服务器如何在不破坏可视化的情况下重命名表格？

PBIP 连接器使用 TMDL 文件的文本编辑和报告定义的 JSON 操作，同时更新模型层和报告层引用，确保重命名操作后不会破坏任何可视化引用。

powerbi-mcp 对比