MCP server to give llms such as Claude, GitHub Copilot etc full PowerBI model context (from input .pbix) through tools based on PBIXRay python
MCP server to give llms such as Claude, GitHub Copilot etc full PowerBI model context (from input .pbix) through tools based on PBIXRay python package. The pbixray mcp server wraps that behind the Model Context Protocol, so an assistant can use it through 14 defined tools rather than through you.
This MCP server exposes the capabilities of PBIXRay as tools and resources for LLM clients to interact with Power BI (.pbix) files.
Everything the assistant can do here goes through one of these:
load_pbix_file — Coreget_tables — Modelget_metadata — Modelget_power_query — Queryget_m_parameters — Queryget_model_size — Modelget_dax_tables — Queryget_dax_measures — Queryget_dax_columns — Queryget_schema — Structureget_relationships — Structureget_table_contents — DataInstallation goes through your MCP client rather than a global install: point it at pbixray-mcp-server on PyPI and it is fetched when the client starts. The copy-paste blocks for Claude Desktop, Claude Code and Cursor are further down this page.
Plenty of developer tooling servers cover similar ground. The differences that matter in practice are scope of access and how much setup stands between you and a working tool call. PBIXRay's toolset — load_pbix_file, get_tables, get_metadata and 11 more — is a fair guide to whether it matches your workflow. It is maintained by jonaolden; worth a glance at recent repository activity before you build anything load-bearing on it.
SyncDev reviews every entry in this directory against the project's own documentation before publishing, and revisits them as servers change.
| Tool | What it does |
|---|---|
| load_pbix_file | Core |
| get_tables | Model |
| get_metadata | Model |
| get_power_query | Query |
| get_m_parameters | Query |
| get_model_size | Model |
| get_dax_tables | Query |
| get_dax_measures | Query |
| get_dax_columns | Query |
| get_schema | Structure |
| get_relationships | Structure |
| get_table_contents | Data |
| get_statistics | Model |
| get_model_summary | Model |
{
"mcpServers": {
"pbixray": {
"command": "wsl.exe",
"args": [
"bash",
"-c",
"source ~/dev/pbixray-mcp/venv/bin/activate && python ~/dev/pbixray-mcp/src/pbixray_server.py"
]
}
}
}Configuration as documented by the project. Restart the client after saving.
Kill hallucinated APIs — version-accurate, up-to-date library documentation injected straight into context.
Microsoft's official browser automation server — drive a real browser through the accessibility tree, no screenshots needed.
GitHub's official server — repos, issues, pull requests, Actions and code security, straight from your assistant.
Issue tracking at the speed of conversation — Linear's official hosted server with OAuth and zero install.
Local repository surgery — status, diffs, commits, branches and history for any repo on disk.
Timezone sanity for AI — current time anywhere and correct conversions, without the model doing date math.