Back to Browse

Horizun Pbi MCP Server

Developer ToolsModerate5.2MCP RegistryLocal
Free

Server data from the Official MCP Registry

Build, audit and repair Power BI Desktop models and PBIP reports with DAX, TMDL and PBIR.

About

Build, audit and repair Power BI Desktop models and PBIP reports with DAX, TMDL and PBIR.

Security Report

5.2
Moderate5.2Moderate Risk

The provided code is a local Power BI MCP server with no hardcoded credentials, no telemetry, and no observed exfiltration. Its network use is limited to downloading version-pinned DLLs and schemas, and the review is limited by truncated source, so the download-integrity and tool-level implementation claims could not be fully verified. Supply chain analysis found 10 known vulnerabilities in dependencies (0 critical, 5 high severity). Package verification found 1 issue.

6 files analyzed · 15 issues found

Security scores are indicators to help you make informed decisions, not guarantees. Always review permissions before connecting any MCP server.

Permissions Required

This plugin requests these system permissions. Most are normal for its category.

File System Read

Reads files on your machine. Normal for tools that analyze or process local data.

File System Write

Writes or modifies files on your machine. Check that this is expected for the tool.

HTTP Network Access

Connects to external APIs or services over the internet.

env_vars

Check that this permission is expected for this type of plugin.

process_spawn

Check that this permission is expected for this type of plugin.

system_info

Check that this permission is expected for this type of plugin.

database

Check that this permission is expected for this type of plugin.

How to Install

Add this to your MCP configuration file:

{
  "mcpServers": {
    "horizun-pbi-mcp": {
      "command": "uvx",
      "args": [
        "horizun-pbi-mcp==2.2.1"
      ]
    }
  }
}

Some servers take additional arguments. See the repository for details.

Documentation

View on GitHub

From the project's GitHub README.

Horizun PBI MCP

CI PyPI Python License

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.

How it works

v2.2.1 · 140 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

claude plugin marketplace add HorizunGroup/horizun-pbi-mcp
claude plugin install horizun-pbi-mcp@horizun

Codex

codex plugin marketplace add HorizunGroup/horizun-pbi-mcp

Then open /plugins, pick the Horizun marketplace and install horizun-pbi-mcp.

Desktop or Code?

Same server, same 140 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 140 pbi_* tools appear.

Your first minute

  1. Open Power BI Desktop with any report.
  2. Ask: "List the Power BI models that are open and connect to the first one."
  3. 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

Audit this PBIP project and explain the highest-risk issues before changing anything.
This measure returns blank for December. Find out why.
Create a report page from this specification, validate it, and show me the layout.
Document every measure in the model and export it to Excel.

What it provides

AreaCapabilities
Live modelDiscover Desktop sessions, run DAX, inspect metadata, refresh, and manage measures through TOM
Semantic modelRead and edit TMDL tables, columns, measures, relationships, roles and calculation groups
Report authoringCreate pages and visuals, clone templates, arrange layouts, apply themes, bookmarks and interactions
ConversionConvert .pbix to .pbip, migrate supported structures and validate the result
QualityAudit models and reports, document schemas, detect broken references and normalize report structures
DeliveryExport verified PDF, Word, Excel and PowerPoint artifacts; ingest SharePoint data read-only

See the tool catalog for all 140 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 .pbip project 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

DocumentPurpose
InstallationSetup, repair, offline installation and MCP client registration
TutorialFirst connection through report authoring
Power BI MCP overviewUse cases, boundaries, safety and first workflow
Tool catalogAll tools, grouped by capability and risk
ArchitectureComponents, boundaries and invariants
SecurityThreat model and operational guarantees
ValidationTMDL/PBIR validation layers and known limits
Migration guideBreaking changes from 1.x to 2.0
ContributingDevelopment workflow and pull-request requirements

Development

git clone https://github.com/HorizunGroup/horizun-pbi-mcp.git
cd horizun-pbi-mcp
python -m pip install -e .
python scripts/fetch_libs.py
python scripts/fetch_pbir_schemas.py
python scripts/doctor.py

Before opening a pull request:

python -m pytest -q
python scripts/doctor.py
python -m tests.contract_utils

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.

Small local models

For Ollama models such as Qwen 3 4B/8B, set the MCP server process environment in your MCP-capable client (not the Ollama model parameters), then restart the server/client:

{"env": {"HORIZUN_PBI_MCP_PROFILE": "local"}}

For a shell launch: $env:HORIZUN_PBI_MCP_PROFILE="local"; horizun-pbi-mcp (PowerShell). The profile exposes 22 tools for start/health → create/open → import → Power Query → inspect → relationships → measures, calculated tables and columns → pages → validate → open/refresh/close Desktop → DAX, with short schemas and compact replies; tools/list is tested below 5,000 estimated tokens (JSON characters / 4). pbi_create_relationship connects existing columns with Desktop closed; defaults are many-to-one, one-direction filtering and overwrite=false. See the local tool list. Use source="pbip" and mode="pbip" while editing with Desktop closed. Open Desktop and refresh with confirm=true before querying data. pbi_find_tool(query="gráfico") searches the entire catalog in Spanish/English, including hidden tools, and reports availability. Set HORIZUN_PBI_MCP_PROFILE=full or remove the variable and restart to access them; calls to hidden tools are rejected in local. Compact replies mark omitted content in _compact; filter tables/DAX or switch to full for more detail. Errors, warnings, validation coverage and recovery journal paths remain available; there is no hard response-size cap on diagnostics. With no variable, existing tools retain their descriptions, parameters and full replies; discovery is the only addition.

Learn to direct it

Horizun Hub teaches, in Spanish, how to direct AI agents in real construction and design work — and how to review what they deliver before you sign it. The course for this MCP is Opera agentes en Power BI: short classes on real construction work, with a verifiable certificate.

New to agents? Level 1 of Opera agentes de IA desde cero is free with an account.

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.

mcp-name: io.github.HorizunGroup/horizun-pbi-mcp

Reviews

No reviews yet

Be the first to review this server!