Power BI XMLA FAQs

Question 1

What is the CData JDBC Driver for Power BI XMLA?

Accepted Answer

The CData JDBC Driver connects to Power BI XMLA, exposing its data as relational SQL models. This allows standard SQL queries and, with this MCP server, natural language queries.

Question 2

What does Power BI XMLA MCP Server by CData do?

Accepted Answer

It enables Large Language Models (LLMs) to query live Power BI XMLA data using natural language. It leverages the CData JDBC Driver to expose Power BI XMLA data as relational SQL models.

Question 3

What is required to setup and run this server?

Accepted Answer

You need to clone the repository, build the server using Maven, download and license the CData JDBC Driver for Power BI XMLA, configure a connection string, and create a .prp file with your connection details.

Question 4

Is this a read-only server?

Accepted Answer

Yes, this specific project builds a read-only MCP server. For read, write, update, delete, and action capabilities, check out the free CData MCP Server for Power BI XMLA (beta).

Question 5

How do I integrate this with Claude Desktop?

Accepted Answer

You need to create a configuration file (claude_desktop_config.json) and add an entry for the Power BI XMLA MCP server, specifying the path to the Java executable, the JAR file, and the .prp file.

Power BI XMLA

About

Key Features

Use Cases