⚠️Alpha version – API 및 동작은 공지 없이 변경될 수 있습니다.

Power BI Desktop MCP Server는 Claude (또는 MCP 클라이언트)가 자연 언어를 사용하여 실행하는 Power BI Desktop 인스턴스에 대해 이야기합니다. Model Context Protocol을 Tabular Object Model에 연결하여 채팅을 떠나지 않고 DAX를 검사, 최적화, 저자를 확인할 수 있습니다.

설치

단계별 설정 (Power BI prerequisites, .NET 라이브러리, 환경 변수)는 INSTALLATION.md에 살고.

현지 개발:

빠른 예

현재 힘 BI 모형에 있는 테이블을 목록으로 만드십시오:

지식 기초에 수출 측정:

표현에 최적화를 실행:

구성

• .env.example]를 .env]로 복사하고 TOM_DLL_PATH]를 설정하면 Microsoft Analysis Services DLLs가 자동 감지되지 않습니다. 옵션 변수는 LOG_LEVEL, MCP_KNOWLEDGE_BASE] 및 POWERBI_WORKSPACE_NAME를 포함합니다.

• Claude Desktop (또는 MCP 호스트)에 CLI 항목을 추가하십시오.

• CLI는 python -m powerbi_mcp.server]의 주위에 얇은 래퍼이므로 배포 및 디버깅을 위해 작업합니다.

특징

• DAX 코드 생성 및 측정 생성
• 측정 및 테이블 metadata 검사
• DAX 최적화기 - 규칙 기반 제안

Power BI Desktop MCP Server

⚠️ Alpha version – APIs and behaviours may change without notice.

Power BI Desktop MCP Server lets Claude (or any MCP client) talk to a running Power BI Desktop instance using natural language. It bridges the Model Context Protocol to the Tabular Object Model so you can inspect, optimize, and author DAX without leaving chat.

Installation

Step-by-step setup (Power BI prerequisites, .NET libraries, environment variables) lives in INSTALLATION.md.

For local development:

pip install -e .
# or install from the current directory:
pip install .

Quick Example

List the tables in your current Power BI model:

python examples/list_model_info.py --include-columns

Export measures to the knowledge base:

python examples/export_measures_to_knowledge_base.py --project "Executive Dashboard"

Run the optimizer on an expression:

python examples/optimize_dax.py --expr "CALCULATE(SUM(Sales[Amount]), FILTER(ALL(Date), Date[Year] = 2024))"

Configuration

• Copy .env.example to .env and set TOM_DLL_PATH if the Microsoft Analysis Services DLLs are not auto-detected. Optional variables include LOG_LEVEL, MCP_KNOWLEDGE_BASE, and POWERBI_WORKSPACE_NAME.

• Add the CLI entry point to Claude Desktop (or any MCP host):

  {
    "mcpServers": {
      "powerbi": {
        "command": "powerbi-mcp-server",
        "args": []
      }
    }
  }
  

• The CLI is a thin wrapper around python -m powerbi_mcp.server, so either invocation works for deployments and debugging.

Features

• DAX code generation and measure creation
• Measure and table metadata inspection
• DAX optimizer with rule-based suggestions
• TMDL import/export helpers
• Knowledge base bridge for storing curated measures
• Example scripts for quick automation (examples/ directory)

Known Issues

• Power BI visuals live outside the XMLA endpoint, so visual creation/editing is not supported.
• The server connects to the most recently opened Power BI Desktop workspace; multiple instances are not yet multiplexed.
• Write operations require the Power BI model to allow external tools and, in some scenarios, elevated permissions.
• pythonnet relies on local Microsoft Analysis Services DLLs; misconfigured TOM_DLL_PATH is the most common setup failure.

Contributing

Pull requests are welcome. Please:

1. Open an issue describing the change if it alters behaviour or APIs.
2. Keep additions formatted with ruff/black style conventions (if configured) and include type hints.
3. Add or update example scripts/tests where it helps illustrate new functionality.