A
licenseC
qualityA
maintenanceLocal-first MCP server for Power BI Desktop automation. Automate semantic model changes, DAX, Power Query, Excel, and report layout from MCP-capable AI clients.
100
MIT
Power BI PBIR MCP
Click on "Install Server".
Wait a few minutes for the server to deploy. Once ready, it will show a "Started" state.
In the chat, type
@followed by the MCP server name and your instructions, e.g., "@Power BI PBIR MCPLoad Supplier Dashboard.Report, summarize pages and visuals, then add a KPI page. Validate after edits."
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 PBIR MCP
Local MCP server for editing Power BI Project reports saved in PBIR format. It uses only the Python standard library and talks MCP over stdio.
Install
From GitHub:
pipx install git+https://github.com/bobzhou-source/powerbi-pbir-mcp.git
codex mcp add powerbi-pbir-report-mcp -- powerbi-pbir-mcpFrom a local clone:
git clone https://github.com/bobzhou-source/powerbi-pbir-mcp.git
cd powerbi-pbir-mcp
python -m pip install -e .
codex mcp add powerbi-pbir-report-mcp -- powerbi-pbir-mcpRestart Codex, then run /mcp.
Related MCP server: pbix-mcp
What It Does
Load
.pbip,.pbir,.Report, ordefinitionfolders.Scaffold Desktop-stable PBIP/PBIR projects.
Read semantic model tables, columns, measures, and source hints.
Batch page, visual, theme, and layout changes with
pbir_apply_plan.Validate JSON shape, bindings, layout bounds, and common Desktop blockers.
Workflow
Example Prompt
Load C:\Reports\Supplier Dashboard.Report, summarize the pages and visuals,
then add an Executive Summary page with KPI cards and a supplier trend chart.
Use pbir_apply_plan and validate after edits.Benchmark
Development
python -m unittest discover -s tests
python -m pbir_mcp_serverPublishing notes are in docs/PUBLISHING.md.
This server cannot be installed
Maintenance
–Maintainers
–Response time
–Release cycle
–Releases (12mo)
Commit activity
Resources
Unclaimed servers have limited discoverability.
Looking for Admin?
If you are the server author, to access and configure the admin panel.
Related MCP Servers
- Alicense-qualityAmaintenanceMCP server for creating, editing, and evaluating Power BI (.pbix/.pbit) files without Power BI Desktop. Supports 101 tools including report creation, data sources, DAX measures, and file manipulation.12MIT
- Alicense-qualityDmaintenanceMCP server for Power BI — local PBIX file analysis, cloud API operations, report export, and semantic model extraction from Power BI Desktop.961MIT
- Alicense-qualityCmaintenanceMCP server for building and inspecting Power BI report visuals by editing PBIR files on disk, enabling page, chart, slicer, and layout management.MIT
Related MCP Connectors
The official MCP Server from Mia-Platform to interact with Mia-Platform Console
MCP server for Klever blockchain smart contract development.
MCP server for interacting with the Supabase platform
Latest Blog Posts
- Who's Calling? MCP Hosts Are an Identity Blind Spot (And the Spec Knows It)By Om-Shree-0709 on .mcpAgent IdentityOAuth 2.1
- Your AI Chatbot Just Exposed Your CEO's Salary to an InternBy Om-Shree-0709 on .Agent IdentityMCP SecurityOAuth Delegation
- Why MCP Servers Need Execution Sandboxing (And Why Your Current Stack Isn't Enough)By Om-Shree-0709 on .Agentic AiPrompt InjectionWebAssembly
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/bobzhou-source/powerbi-pbir-mcp'
If you have feedback or need assistance with the MCP directory API, please join our Discord server