Open-source MCP server for Power BI Desktop, DAX, PBIP, TMDL and PBIR automation.
Quick Install
Automated & IDE SetupCopy the AI prompt to install this server into Claude Code, Cursor, or another agent — or use 1-click editor setup below.
One-click editor setup isn’t available for this listing yet — we don’t have a confirmed install command, and we’d rather show nothing than point your editor at the wrong package or host. Follow the project’s own setup instructions, linked above.
Manual Client & Custom JSON ConfigExpand JSON ▾
No confirmed setup config for this listing yet. We only publish a config block when the install details come from the project itself — its README, its docs, or a verified owner. We haven’t found those for Horizun PBI MCP, and we’d rather show nothing than a guess you’d paste into your client. Follow the project’s own setup instructions for the current steps.
Capabilities & Tool Schemas (27)
Inspect callable tools, capabilities, and parameters exposed to AI agents by Horizun PBI MCP.
pbi_list_desktop_modelslists open models (port, connection string, catalog, number of tables).
pbi_select_modelsets the active model (by `port` if there are several).
pbi_run_daxruns DAX (`query`, `max_rows`).
pbi_test_connectionvalidates the active connection.
pbi_validate_measuresvalidates measure DAX WITHOUT modifying the model (dry-run with `DEFINE MEASURE`); useful before creating them.
pbi_validate_desktop_renderopens a `.pbix`/`.pbip`, captures the exact window by PID without depending on focus and only closes Desktop if the tool itself opened it.
Documentation Overview
Horizun PBI MCP
Build and fix Power BI reports by describing what you want. Ask in plain language; the server runs the DAX, edits the model, writes the report pages — and checks its own work afterwards.
No licence, no API key, no paid plan
It runs as a local process on your own Windows machine, so the free apps are enough: install it in ChatGPT Desktop or Claude Desktop on their free tiers and start asking. No OpenAI or Anthropic API key, no subscription, no server of ours in the middle — and Power BI Desktop is free as well. One click installs it and it prepares its own runtime: no Python, no JSON to edit.
v2.1.1 · 139 tools · Windows · ChatGPT Desktop Free · Claude Desktop Free · Claude Code · Codex
New to the project? Start with what this Power BI MCP is, when to use it, and what it deliberately does not do.
Install
No repository clone, manual DLL download or .mcp.json editing is required.
Pick the line that matches you.
ChatGPT Desktop Free
Run the verified one-paste installer from docs/INSTALL.md,
restart ChatGPT Desktop, then open Plugins → Personal and install
Horizun PBI MCP. No OpenAI API key is required.
Claude Desktop Free
Download the .mcpb from the
latest release
and double-click it. Claude Desktop supplies the bootstrap runtime; no Claude
Code install or JSON editing is required. It will say the extension is not
verified by Anthropic — what it says about anything installed outside its own
directory — and let you continue.
Claude Code
Codex
Then open /plugins, pick the Horizun marketplace and install
horizun-pbi-mcp.
Desktop or Code?
Same server, same 139 tools, same local runtime — install both and they share it. Pick by what you are doing: Claude Desktop to use Power BI, in chat, one click, free tier. Claude Code to build — it adds the terminal, git and your repo, and loads tool schemas on demand instead of all at once.
On a new PC, the verified one-paste installer prepares the
prerequisites without administrator rights. First setup takes a few minutes:
run pbi_install_status until ready, restart once, and confirm the 139 pbi_* tools appear.
Your first minute
- Open Power BI Desktop with any report.
- Ask: "List the Power BI models that are open and connect to the first one."
- Ask: "Run a read-only DAX query that returns revenue by month for this year."
If step 2 answers, everything works.
Things worth asking for
What it provides
| Area | Capabilities |
|---|---|
| Live model | Discover Desktop sessions, run DAX, inspect metadata, refresh, and manage measures through TOM |
| Semantic model | Read and edit TMDL tables, columns, measures, relationships, roles and calculation groups |
| Report authoring | Create pages and visuals, clone templates, arrange layouts, apply themes, bookmarks and interactions |
| Conversion | Convert .pbix to .pbip, migrate supported structures and validate the result |
| Quality | Audit models and reports, document schemas, detect broken references and normalize report structures |
| Delivery | Export verified PDF, Word, Excel and PowerPoint artifacts; ingest SharePoint data read-only |
See the tool catalog for all 139 tools and their risk classifications.
Why it is safe to point at real work
- Local-first: Power BI Desktop communication stays on
localhost. - No telemetry, and the MCP server needs no account.
- Project writes stay inside the active project directory.
- Every project write makes a backup and is re-read to confirm it landed.
- Destructive tools require
confirm=true. - JSON writes are atomic; invalid JSON is never written over good JSON.
- Downloaded runtime components are version-pinned and SHA-256 verified.
- Logs go to stderr or files, so stdout stays a clean JSON-RPC channel.
Full guarantees and failure behavior: security model and recovery guide. Report vulnerabilities privately as described in SECURITY.md.
Requirements
- Windows 10 or 11.
- Python 3.10 or newer.
- Power BI Desktop — only for the live layer (DAX, refresh, capture, render checks).
- A
.pbipproject with PBIR enabled, for report-file authoring. - Node.js 20+ only for the optional Microsoft PBIR validator.
Claude Code, Codex and Power BI Desktop are external programs; this project does
not install them. Without Desktop the .pbip tools still work — the live tools
do not.
Known limits
- Power BI does not expose pages or visuals through its live local endpoint, so those are edited in PBIR files while Desktop is safely closed.
mode="both"is disabled for dual live/disk writes: Desktop being open and a PBIP project being safe to edit are mutually exclusive states.- The server does not publish to or refresh the Power BI Service.
- Three PBIR schemas referenced by Power BI are not published by Microsoft; affected writes fail closed instead of guessing.
Documentation
| Document | Purpose |
|---|---|
| Installation | Setup, repair, offline installation and MCP client registration |
| Tutorial | First connection through report authoring |
| Power BI MCP overview | Use cases, boundaries, safety and first workflow |
| Tool catalog | All tools, grouped by capability and risk |
| Architecture | Components, boundaries and invariants |
| Security | Threat model and operational guarantees |
| Validation | TMDL/PBIR validation layers and known limits |
| Migration guide | Breaking changes from 1.x to 2.0 |
| Contributing | Development workflow and pull-request requirements |
Development
Before opening a pull request:
The MCP contract is frozen and checked against tests/golden/tools_v1.json.
Real .pbix, .pbip, credentials, DLLs, outputs and backups are never
committed. See AGENTS.md for the repository invariants.
License
Apache License 2.0. See LICENSE and NOTICE.
MCP Registry
This package is the one published under the server name below. The registry
reads this line from the README of the PyPI package to confirm that whoever
publishes the metadata also owns the package, so it has to live here rather
than in .mcp/server.json alone.
Related MCP Servers
Adoption & maintenance
Factual signals from GitHub, npm, and our automated checks — not a rating.
GitHub stars
16
Stargazers on the source repository.
Last commit
19d ago
Most recent push to the default branch.
Tools exposed
27
Callable tools this server registers over MCP.
Directory activity
1 views
Config copies, upvotes, and views on AllMCPs.
Reviews
No reviews yet — be the first to share how this listing worked for you.
Frequently Asked Questions about Horizun PBI MCP
AllMCPs Directory Badge
Showcase your server listing on GitHub or your project documentation. Embed this dynamic SVG badge to highlight official listing status and live engagement.
Badge Style:
Live Dynamic SVG Preview
Markdown (GitHub README)
[](https://allmcps.com/mcp/horizun-pbi-mcp)HTML Embed
<a href="https://allmcps.com/mcp/horizun-pbi-mcp"><img src="https://allmcps.com/api/badge/horizun-pbi-mcp?style=directory" alt="Horizun PBI MCP on AllMCPs" /></a>Technical Specs & Signals
CategoryData Visualization
12/12 checks healthy over the last 45d
48Quality signal: Fair · 48/100How this signal is calculated ▾
Server availabilityNot measured
Not scored for repo-hosted servers — we can't reach the running server, only its GitHub page. Hosted MCP endpoints are health-checked live.
Verified ownership10/20
Documentation & tools20/30
Adoption & activity6/15
Community engagement0/10
A guidance signal from public completeness & health data — not a user rating. New listings start lower and rise as they add docs, get verified, and grow adoption. Signals we can't observe for a listing are skipped, not counted against it.
Own this project?
This directory is pre-filled from public sources. Claim via GitHub README, site badge, or DNS TXT to unlock edit access and the Official badge — proof is checked automatically, then reviewed by our team.
Free dofollow backlink: add your website and place the AllMCPs badge on it — no claim needed. We detect it automatically and keep it verified as long as the badge stays live.
Claim & get free dofollowShare & Embed
Add our SVG badge (dark/light directory styles) or embeddable widget to your site.