广告合作
MCP.so
登录
P

Power BI XMLA MCP Server by CData

@CDataSoftware

代码仓库

基本信息

分类

数据与分析

传输方式

stdio

作者

CDataSoftware

提交者

Cameron Leblanc

关于 Power BI XMLA MCP Server by CData

This project builds a read-only MCP server. For full read, write, update, delete, and action capabilities and a simplified setup, check out our free [CData MCP Server for Power BI XMLA (beta)](https://www.cdata.com/download/download.aspx?sku=LGZK-V&type=beta).

#powerbi#mcp-server#data-access

Power BI XMLA MCP Server by CData 配置

使用下面的配置,将此服务器添加到你的 MCP 客户端。

{
  "mcpServers": {
    "{classname_dash}": {
      "command": "PATH\\TO\\java.exe",
      "args": [
        "-jar",
        "PATH\\TO\\CDataMCP-jar-with-dependencies.jar",
        "PATH\\TO\\power-bi-xmla.prp"
      ]
    }
  }
}

Power BI XMLA MCP Server by CData 工具

工具列表暂未提供

当前收录暂时没有可展示的工具列表，不代表服务没有工具。请查阅项目文档了解支持的能力。

工具是从 README 中自动提取的。维护者可以在 ## Tools 标题下列出工具,即可填充这部分内容。

概览

What is Power BI XMLA MCP Server by CData?

CData's read-only Model Context Protocol (MCP) Server that allows LLMs (like Claude Desktop) to query live data from Power BI XMLA using the CData JDBC Driver. It wraps the driver into a simple MCP interface, enabling natural language questions without writing SQL.

How to use Power BI XMLA MCP Server by CData?

Clone the repository, build with mvn clean install, download and license the CData JDBC Driver for Power BI XMLA, then create a .prp property file with connection details. Configure Claude Desktop’s claude_desktop_config.json to point to the JAR and .prp file, then restart the client. The server runs via stdio and must be on the same machine as the client.

Key features of Power BI XMLA MCP Server by CData

  • Read-only access to live Power BI XMLA data
  • Exposes tables and columns as MCP tools
  • Allows natural language queries via LLM clients
  • Uses the CData JDBC Driver for connectivity
  • Supports OAuth‑based authentication

Use cases of Power BI XMLA MCP Server by CData

  • Ask an LLM to summarize or analyze Power BI XMLA data
  • Explore available tables and columns without writing SQL
  • Retrieve live business insights from Power BI XMLA through conversation
  • Enable non‑technical users to query Power BI XMLA using natural language

常见问题

1

Is this server read-only?

Yes, this project is a read-only MCP server. For full CRUD and action capabilities, use the free CData MCP Server for Power BI XMLA (beta) linked in the README.

2

What are the runtime requirements?

The server requires Java and a licensed CData JDBC Driver for Power BI XMLA. It communicates over `stdio` and must run on the same machine as the MCP client.

3

How do I configure authentication?

Authentication is handled in the JDBC connection string. For OAuth-based data sources, the Connection String utility will open a browser for authentication.

4

What tools does the server expose?

It exposes three tools: `{server}_get_tables`, `{server}_get_columns`, and `{server}_run_query` (SELECT only, since the server is read-only).

5

Where can I get help?

For connection issues, contact CData Support. For MCP server feedback, join the CData Community. Both links are in the README’s Troubleshooting section.

评论

数据与分析 分类下的更多 MCP 服务器

Aard

Braddon Lance

Aard connects Macroeconomic and other official data from 170+ publishers including World Bank, IMF, BIS, ECB, Eurostat, and National Statistical Offices. Aard is powered by a large graph of the metadata universe and an

Sugra API MCP

Sugra Systems, Inc.

Official MCP server for the Sugra API, giving AI agents source-attributed access to 1,500+ endpoints across 36 data domains from 160+ primary sources. Covers markets, economics, company fundamentals, government, news, cl

1

PixelFlow

PixelFlow

Server-side conversion tracking for Meta, TikTok, etc. Set up tracking and ask about events.

YouTube MCP Server

HasData

Hosted YouTube MCP server for search, video metadata, channel data and timestamped transcripts. Connect Claude, Cursor or other MCP clients with HasData; no YouTube API key required.

6

API Direct

API Direct

Search and read public data from X/Twitter, Reddit, YouTube, Instagram, TikTok, Facebook, Threads, Bluesky, Trustpilot, Amazon, Google Maps, news, forums and the web. 90+ read-only tools plus ready-made research playbook

广告合作