power-bi-xmla-mcp-server-by-cdata

power-bi-xmla-mcp-server-by-cdata

0
databasesdeveloper_tools

This project is a read-only MCP server that allows LLMs to query Power BI XMLA data through a simplified interface. It integrates with CData JDBC Drivers to expose data as relational SQL models, enabling interaction with natural language questions.

Power BI XMLA MCP Server by CData

Overview

CData's Model Context Protocol (MCP) Server for Power BI XMLA is designed to provide a read-only MCP interface for querying live Power BI XMLA data. This server leverages the CData JDBC Driver to expose Power BI XMLA data as relational SQL models, enabling language models like Claude Desktop to interact with the data using natural language.

Features

  • Read-only MCP server for Power BI XMLA
  • Uses CData JDBC Driver to connect and query data
  • Allows LLMs to retrieve live data without SQL knowledge

Setup Guide

  1. Clone and build the repository.
  2. Install and license the CData JDBC Driver for Power BI XMLA.
  3. Configure the connection and create a .prp file for JDBC connection.

Usage

Once configured, the AI client can use the server's built-in tools to access the data by asking questions. Example questions include:

  • "What is the correlation between my closed won opportunities and the account industry?"
  • "How many open tickets do I have in the SUPPORT project?"

License

This server is licensed under the MIT License.