How do I use Power BI Desktop Local MCP Server?

1. Click on "Install Server". 2. Wait a few minutes for the server to deploy. Once ready, it will show a "Started" state. 3. In the chat, type @ followed by the MCP server name and your instructions, e.g., "@Power BI Desktop Local MCP Server list active Power BI Desktop instances" That's it! The server will respond to your query, and you can continue using it as needed. Here is a step-by-step guide with screenshots.

Power BI Desktop Local MCP Server

by 1mestre

Overview Schema Related Servers Score Discussions

Python

Local

⚡ Power BI Hermes Framework — Multi-Agent Executive Dashboard Engine

A complete, model-agnostic engineering framework designed to equip autonomous AI agents (Hermes, Anti-Gravity, Claude Code, Cursor, Windsurf, Cline) with the exact skills, script engines, layout formulas, and verification guardrails needed to build deterministic, high-contrast, executive-ready Power BI Projects (.pbip / .pbir / .tmdl) in a single pass.

🎯 What is the Power BI Hermes Framework?

This framework eliminates infinite correction loops, unstyled default light mode visuals, layout overlaps, and corrupted TMDL files by integrating 4 core architectural components:

Master Orchestrator & 7 Specialized Sub-Skills (.agents/skills/ & ~/.hermes/skills/) for 8-phase workflow automation, multi-page layout distribution, DAX measure injection, and schema locks.
Deterministic Python Verification Engine (framework/scripts/) for programmatic theme application, WCAG contrast validation, per-page visual boundary enforcement, and LF line ending sanitization.
6 Absolute Guardrails & 5 Core Principles of PBIR Styling with strict grid geometry for 1280x720 canvas layouts (max 5 KPI cards per row, width=232px, gap=20px, margin=20px).
Desktop SSAS MCP Server Integration (server.py via launch.py using powerbi-local) for live DAX query execution, port discovery, and TMDL schema inspection directly against running Power BI Desktop instances on Windows.

Related MCP server: MCP Server for Power BI

⚡ Quick Start & Universal Agent Setup

🤖 Option A: Universal Prompt for Any AI Agent (Hermes, Anti-Gravity, Claude, Cursor)

Copy and paste this prompt into a new session with your AI agent:

Task: Initialize and activate the Power BI Hermes Framework.

1. Clone or pull repository: https://github.com/1mestre/desktop-ssas-mcp.git
2. Setup Python environment and dependencies:
   python -m venv .venv
   .\.venv\Scripts\activate
   pip install -r requirements.txt
3. Activate Framework Skills:
   - For Hermes: Execute skill_view(name='powerbi-orchestrator')
   - For Anti-Gravity / Claude Code / Cursor: Load .agents/skills/powerbi-orchestrator/SKILL.md as the active skill context.
4. Mandatory Execution Rules:
   - Phase 6: ALWAYS run: python framework/scripts/apply_theme.py "<Project>.pbip" --theme slate-terracotta
   - Phase 7: ALWAYS run: python framework/scripts/check_overlaps.py "<Project>.Report"
5. Confirm framework readiness to begin dashboard generation.

🔧 Option B: Manual Installation by Platform

1. Installation into Hermes (Local User Profile)

xcopy /E /I /Y .agents\skills\* %LOCALAPPDATA%\hermes\skills\

2. Installation into Project Workspace (Anti-Gravity / Claude Code / Cursor / Windsurf)

xcopy /E /I /Y .agents\skills\* .agents\skills\

3. MCP Server Configuration (Optional for Live SSAS DAX Queries)

Hermes Config (`config.yaml`)

mcp_servers:
  powerbi-local:
    command: C:/path/to/desktop-ssas-mcp/.venv/Scripts/python.exe
    args:
      - C:/path/to/desktop-ssas-mcp/launch.py
    connect_timeout: 30
    timeout: 120

Cursor / Cline / Windsurf Config (`mcp.json` / `claude_desktop_config.json`)

{
  "mcpServers": {
    "powerbi-local": {
      "command": "C:\\path\\to\\desktop-ssas-mcp\\.venv\\Scripts\\python.exe",
      "args": [
        "C:\\path\\to\\desktop-ssas-mcp\\launch.py"
      ]
    }
  }
}

📁 Repository Architecture & Directory Structure

desktop-ssas-mcp/
├── README.md                           # Master framework documentation & setup guide
├── requirements.txt                    # Python dependencies (fastmcp, pythonnet, etc.)
├── launch.py                           # Environment isolator (prevents PYTHONPATH collisions)
├── server.py                           # MCP server tools (list_instances, get_schema, execute_dax, add_measure_to_tmdl, generate_html_visual)
├── pbi_connector.py                    # ADOMD.NET connector & active SSAS port scanner
├── html_generators.py                  # HTML visual generators (bar, donut, KPI, column, line, table)
├── fix_tmdl_format.py                  # TMDL formatString sanitizer
├── new_powerbi_dashboard.py            # Batch automation suite
├── framework/                          # 📦 Core Framework Engine
│   ├── SKILL.md                        # Framework Master Entry Point
│   ├── DESIGN_GUIDELINES.md            # Visual aesthetics, WCAG contrast & theme tokens
│   ├── references/
│   │   └── guardrails.md               # 6 non-negotiable pre-flight guardrails
│   └── scripts/                        # 🛠️ Verification Script Engine
│       ├── apply_theme.py              # Visual styling & theme engine (Dark & Light modes)
│       ├── check_overlaps.py           # Per-page visual overlap & 1280x720 boundary checker
│       ├── validate_pbip.py            # 54-check PBIP structural validator
│       ├── fix_tmdl.py                 # TMDL CRLF→LF, BOM & syntax sanitizer
│       ├── audit_csv.py                # Pre-flight CSV auditor (BOM, quotes, delimiters)
│       └── csv_fix.py                  # Programmatic CSV cleaner
└── .agents/
    └── skills/                         # 🤖 AI Agent Skill Suite (Hermes, Anti-Gravity, Claude, Cursor)
        ├── powerbi-orchestrator/       # MASTER SKILL (Loads all sub-skills automatically)
        ├── powerbi-tmdl-modeling/      # DAX measures, TMDL formatting & partition preservation
        ├── powerbi-design-layout-themes/ # 1280x720 Grid math, 5 themes & WCAG 2.1 AA rules
        ├── powerbi-pbir-visuals-specs/  # Visual types, queryState projections & 2.9.0 schema lock
        ├── powerbi-pbir-troubleshooting/ # 5 Core PBIR Styling Principles & trap fixes
        ├── powerbi-visual-styling/      # Visual-type specific text & container background rules
        ├── powerbi-csv-audit/           # Pre-flight CSV data pipeline audit
        └── pbir-dark-theme-styling/     # Dark theme JSON exact property templates

🎯 Orchestrated 8-Phase Workflow

All AI agents executing tasks with this framework MUST follow this 8-phase workflow:

Phase	Name	Task Description	Mandatory Script / Tool Gate
0	Interactive Discovery	Prompt user for data source path, dashboard purpose, audience, and theme preference.	`audit_csv.py` (if input is CSV)
1	Environment Check	Confirm PBIP directory structure and ensure Power BI Desktop is closed.	`validate_pbip.py`
2	Data Analysis	Inspect semantic model schema and sample DAX query results.	`get_schema()` / `execute_dax()` via MCP
3	Visual Design	Select one of 5 premium themes and establish page layout grid.	`powerbi-design-layout-themes`
4	DAX Modeling	Inject DAX measures into `.tmdl` files (`newline='\n'`).	`fix_tmdl.py`
5	Visual Creation	Generate visuals using `pbir add visual <type>` (never manual JSON).	`pbir-cli`
6	Theme & Styling	MANDATORY EXECUTION: Apply theme and patch `page.json` backgrounds.	`python scripts/apply_theme.py "<Project>.pbip" --theme slate-terracotta`
7	Final Verification	MANDATORY EXECUTION: Verify 0 overlaps and 52/54+ PBIP checks.	`python scripts/check_overlaps.py` & `validate_pbip.py`
8	Human Review	Delete `cache.abf` and prompt user to open `.pbip` in Power BI Desktop.	—

🛡️ 6 Absolute Guardrails & ⚡ 5 Core Principles of PBIR Styling

🛑 6 Absolute Guardrails (Violations = Broken Dashboard)

RULE #1: NEVER create model.bim / TMDL from scratch. The user MUST load data into Power BI Desktop and save as .pbip.
RULE #2: ALWAYS close Power BI Desktop before editing files. Run taskkill /IM PBIDesktop.exe /F.
RULE #3: NEVER create visual.json manually. ALWAYS use pbir add visual <type>.
RULE #4: TMDL requires strictly LF line endings (\n), NOT CRLF (\r\n). Python files MUST use open(..., newline='\n').
RULE #5: ALWAYS delete cache.abf before reopening Power BI Desktop. (<Project>.SemanticModel/.pbi/cache.abf).
RULE #6: NEVER use % in DAX measure names. Use Pct instead (Avg Discount Pct).

⚡ 5 Core Principles of PBIR Styling & Layout

Principle	Core Rule	Implementation Detail
1. Custom Visual Binding	Dual projection in `queryState`	Duplicate field projections under both `"Values"` AND manifest role (`"content"` for HTML Content).
2. Canvas Background	Direct `page.json` override	Edit `objects.background` in `page.json`. NEVER include `show` property in `page.json` (triggers schema error).
3. Color Key Mapping	Strict keys per visual type	Card:`labels`/`categoryLabels`, Donut:`labels`/`legend`, Bar:`dataPoint`/`labelColor`, Slicer:`items`/`header`.
4. Multi-Color Bars	`scopeId` selectors in `dataPoint`	Inject `scopeId` Comparison array per category value. `Comparison.Right` contains `Literal` directly without outer `expr`.
5. Grid Math & Page Limits	Rigid 1280x720 grid & page limits	Max 5-6 visuals per page. Max 5 KPIs per row (`w=232px`, `gap=20px`, `margin=20px`). Formula: $x_i = 20 + i \times 252$.

🎨 5 Premium Themes Catalogue

apply_theme.py includes 5 complete built-in visual profiles for dark and light modes:

Theme Name	Mode	Palette Overview	Recommended Usage
`slate-terracotta`	Dark	Canvas `#0F3040`, Cards `#1A4055`, Text `#F8FAFC`, Accents `#A56F63`, `#D99B7F`	Executive / Financial (Default)
`magenta-blossom`	Light	Canvas `#FFFFFF`, Cards `#F9FAFB`, Text `#111827`, Accents `#92003A`, `#F62477`	Marketing & Social Media
`ecotone-spring`	Light	Canvas `#F5F2EB`, Cards `#FAF8F3`, Text `#1A1A2E`, Accents `#769826`, `#A1CB35`	Environment & Sustainability
`roasted-espresso`	Dark	Canvas `#1A0F0D`, Cards `#2D1814`, Text `#F8FAFC`, Accents `#60241E`, `#E77B49`	Premium Operations & Retail
`vintage-nordic`	Light	Canvas `#EBEDE3`, Cards `#F0F2E9`, Text `#0B1849`, Accents `#0B1849`, `#124D1C`	Corporate & Formal Reporting

🛠️ Verification Script Engine Reference

1. `apply_theme.py` (Theme Application & Visual Styling Engine)

Applies complete visual styling to all page.json files, CY26SU05.json, and visual.json containers:

python framework/scripts/apply_theme.py "F:/projects/Sales.pbip" --theme slate-terracotta

2. `check_overlaps.py` (Visual Layout & Boundary Checker)

Checks every page for visual collisions, boundary overflow (x+w > 1280 or y+h > 720), and page overcrowding (>6 visuals):

python framework/scripts/check_overlaps.py "F:/projects/Sales.pbip"

3. `validate_pbip.py` (54-Check PBIP Validator)

Runs full structural analysis across .pbip, .pbir, pages.json, visual.json, and .tmdl files:

python framework/scripts/validate_pbip.py "F:/projects/Sales.pbip"

4. `fix_tmdl.py` (TMDL Line Ending & BOM Sanitizer)

Enforces LF line endings (\n), removes UTF-8 BOM, and quotes unquoted formatString entries in TMDL files:

python framework/scripts/fix_tmdl.py "F:/projects/Sales.SemanticModel/definition/"

5. `audit_csv.py` (Pre-flight CSV Auditor)

Audits raw input CSV files for unbalanced quotes, inconsistent column counts, UTF-8 BOM, and CRLF:

python framework/scripts/audit_csv.py "data/sales_raw.csv"

🔌 Desktop SSAS MCP Server Tools API (`powerbi-local`)

When running Power BI Desktop on Windows, the MCP server (server.py) exposes these 5 native tools:

Tool	Purpose	Output Format
`list_instances()`	Auto-scans local AppData to detect active Power BI Desktop SSAS ports.	`[{"path": "...", "port": "54321"}]`
`get_schema(port)`	Retrieves full semantic model schema (tables, columns, data types, measures).	`[{"Name": "Sales", "Columns": [...]}]`
`execute_dax(port, query)`	Executes live DAX `EVALUATE` queries against the active SSAS engine.	`[{"Sales[Country]": "Mexico", "Total": 125000}]`
`add_measure_to_tmdl(tmdl_path, name, expression, format_string)`	Appends DAX measures safely into `.tmdl` files before partition blocks.	Success / error string
`generate_html_visual(...)`	Generates self-contained HTML visual measures for Daniel Marsh-Patrick's HTML Content visual.	`{"html": "...", "tmdl_result": "..."}`

🔗 Credits & References

Skill Creator Guidelines — Anthropic
Power-BI-Visuals-Using-Claude-AI-HTML-DAX — Fasaclox
HTML Content Visual — Daniel Marsh-Patrick
Model Context Protocol — Anthropic

This server cannot be installed

license - not found

quality - not tested

maintenance

How are these scores calculated?

Maintenance

–Maintainers

–Response time

–Release cycle

–Releases (12mo)

Commit activity

Resources

GitHub Repository

Need Help?

Related Servers

Unclaimed servers have limited discoverability.

Looking for Admin?

If you are the server author, to access and configure the admin panel.

Latest Blog Posts

Who's Calling? MCP Hosts Are an Identity Blind Spot (And the Spec Knows It)
By Om-Shree-0709 on July 25, 2026.
mcp
Agent Identity
OAuth 2.1
Your AI Chatbot Just Exposed Your CEO's Salary to an Intern
By Om-Shree-0709 on July 2, 2026.
Agent Identity
MCP Security
OAuth Delegation
Why MCP Servers Need Execution Sandboxing (And Why Your Current Stack Isn't Enough)
By Om-Shree-0709 on June 30, 2026.
Agentic Ai
Prompt Injection
WebAssembly

MCP directory API

We provide all the information about MCP servers via our MCP API.

curl -X GET 'https://glama.ai/api/mcp/v1/servers/1mestre/desktop-ssas-mcp'

If you have feedback or need assistance with the MCP directory API, please join our Discord server