P

Pbixray MCP Server

PBIXRay MCP Server是一個基於Model Context Protocol的服務器,提供對Power BI(.pbix)文件的分析和交互功能,包括數據模型探索、查詢語言訪問和數據結構分析等工具。
2.5分
12

What is PBIXRay MCP Server?

PBIXRay MCP Server is a bridge that allows AI assistants to interact with Power BI files. It provides tools to explore data models, analyze structures, and access query languages (DAX/M) within .pbix files.

How to use PBIXRay MCP Server?

Simply configure the server in your AI client, then ask your assistant to analyze Power BI files. The server handles all the technical details while you get clear insights.

When should I use it?

Perfect for when you need to quickly understand Power BI files without opening Power BI Desktop, or when you want AI assistance with data model analysis.

Key Features

Data Model ExplorationDiscover tables, relationships and metadata in Power BI data models
Query Language AccessView Power Query (M) code and DAX expressions (measures, calculated columns)
Data Structure AnalysisExamine schemas, relationships and sample table contents
Configurable ToolsEnable/disable specific features based on your security needs

Pros and Cons

Advantages
No Power BI Desktop required for basic analysis
AI-friendly interface through natural language
Lightweight alternative to full Power BI installation
Configurable security through tool restrictions
Limitations
Requires WSL for Windows users (path conversion needed)
Doesn't support visualizations or report editing
Limited to analysis of existing .pbix files

Getting Started

Install the server
Install via pip or from source (see installation instructions)
Configure your AI client
Add server configuration to your AI client's settings file
Start analyzing
Ask your AI assistant to load and examine .pbix files

Example Scenarios

Exploring a new Power BI fileWhen you receive a new Power BI report and want to quickly understand its structure
Finding specific measuresWhen you need to locate and understand specific calculations in a complex model

Frequently Asked Questions

Why do I need to convert Windows paths to WSL paths?
Can I edit the Power BI file through this server?
How do I limit sensitive data exposure?

Additional Resources

PBIXRay GitHub
The core PBIXRay library powering this server
Model Context Protocol
Learn about the MCP standard this server implements
Power BI Documentation
Official Power BI resources from Microsoft
安裝
複製以下命令到你的Client進行配置
{
  "mcpServers": {
    "pbixray": {
      "command": "wsl.exe",
      "args": [
        "bash",
        "-c",
        "source ~/dev/pbixray-mcp/venv/bin/activate && python ~/dev/pbixray-mcp/src/pbixray_server.py"
      ]
    }
  }
}

{
    "mcpServers": {
      "pbixray": {
        "command": "wsl.exe",
        "args": [
          "bash",
          "-c",
           "source ~/dev/pbixray-mcp/venv/bin/activate && python ~/dev/pbixray-mcp/src/pbixray_server.py --max-rows 100 --page-size 50 --disallow get_power_query"
         ],
         "env": {}
       }
     }
   }
注意:您的密鑰屬於敏感信息,請勿與任何人分享。
精選MCP服務推薦
B
Baidu Map
已認證
百度地圖MCP Server是國內首個兼容MCP協議的地圖服務,提供地理編碼、路線規劃等10個標準化API接口,支持Python和Typescript快速接入,賦能智能體實現地圖相關功能。
Python
702
4.5分
M
Markdownify MCP
Markdownify是一個多功能文件轉換服務,支持將PDF、圖片、音頻等多種格式及網頁內容轉換為Markdown格式。
TypeScript
1.7K
5分
F
Firecrawl MCP Server
Firecrawl MCP Server是一個集成Firecrawl網頁抓取能力的模型上下文協議服務器,提供豐富的網頁抓取、搜索和內容提取功能。
TypeScript
3.8K
5分
S
Sequential Thinking MCP Server
一個基於MCP協議的結構化思維服務器,通過定義思考階段幫助分解複雜問題並生成總結
Python
258
4.5分
E
Edgeone Pages MCP Server
EdgeOne Pages MCP是一個通過MCP協議快速部署HTML內容到EdgeOne Pages並獲取公開URL的服務
TypeScript
249
4.8分
N
Notion Api MCP
已認證
一個基於Python的MCP服務器,通過Notion API提供高級待辦事項管理和內容組織功能,實現AI模型與Notion的無縫集成。
Python
119
4.5分
C
Context7
Context7 MCP是一個為AI編程助手提供即時、版本特定文檔和代碼示例的服務,通過Model Context Protocol直接集成到提示中,解決LLM使用過時信息的問題。
TypeScript
5.2K
4.7分
M
Magic MCP
Magic Component Platform (MCP) 是一個AI驅動的UI組件生成工具,通過自然語言描述幫助開發者快速創建現代化UI組件,支持多種IDE集成。
JavaScript
1.7K
5分
AIbase
智啟未來,您的人工智慧解決方案智庫
© 2025AIbase