{"id":"cdatasoftware-power-bi-xmla-mcp-server-by-cdata","name":"power-bi-xmla-mcp-server-by-cdata","af_score":48.8,"security_score":43.5,"reliability_score":23.8,"what_it_does":"Provides a local, read-only MCP server that wraps the CData JDBC Driver for Power BI XMLA, exposing Power BI XMLA data as MCP tools (get tables/columns and run_query) for LLM clients such as Claude Desktop.","best_when":"You have a local machine where an MCP-capable client can run the server via stdio, and you want agent-friendly access to Power BI XMLA using natural language over a JDBC-backed SQL surface.","avoid_when":"You need a network-exposed API, fine-grained authorization per user, or robust operational controls (pagination, retries, rate-limit handling) documented for automated agents.","last_evaluated":"2026-04-04T19:49:14.092070+00:00","has_mcp":true,"has_api":false,"auth_methods":["MCP server runs locally; authentication is delegated to the CData JDBC Driver connection string (may use OAuth in the driver)."],"has_free_tier":false,"known_gotchas":["Server uses stdio; must run on the same machine as the MCP client.","Only read-only capabilities are advertised; agent attempts at write/update/delete may fail or be unsupported.","The SQL tool accepts an arbitrary SQL string; agents must constrain to safe/SELECT queries to avoid unexpected behavior and high load.","Output is described as CSV for get_tables/get_columns; agents should parse CSV reliably and handle large outputs."],"error_quality":0.0}