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.
Last updated
100
MIT
powerbi-mcpb
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., "@powerbi-mcpbShow me all Power BI reports in the local folder"
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.
powerbi-mcpb
MCP Bundle for local Power BI report files (.pbix, .pbip, .pbit). No Azure, no cloud API, no sign-in.
Architecture
powerbi-mcpb/
├── src/
│ ├── index.ts
│ ├── helpers.ts
│ ├── local/
│ │ ├── paths.ts # LOCAL_REPORTS_DIR
│ │ ├── scan.ts # Find reports on disk
│ │ ├── pbixArchive.ts # Unzip .pbix / .pbit
│ │ ├── pbixReader.ts
│ │ └── pbipReader.ts # Read .pbip project folders
│ └── tools/
│ └── localReports.ts # list_local_reports, get_local_report, ...
├── manifest.json
└── ...Legacy cloud tools (workspaces.ts, reports.ts, datasets.ts) remain in the repo but are not registered — they targeted api.powerbi.com.
Related MCP server: pbix-mcp
Prerequisites
Node.js 18+
Power BI report files in a folder on disk
Dev setup
npm install
npm run build
npm run bundle$env:LOCAL_REPORTS_DIR = "C:\Your\Reports"
npm startInstall (MCP bundle)
Pick your reports folder when prompted (local_reports_folder). Rebuild with npm run pack.
Tools
Tool | Description |
| Scan folder for |
| Pages, tables (if available), archive listing |
| Tables/columns from |
Authentication
None. Files are read from disk only.
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.Last updated12MIT
- Alicense-qualityDmaintenanceMCP server for Power BI — local PBIX file analysis, cloud API operations, report export, and semantic model extraction from Power BI Desktop.Last updated119MIT
- Alicense-qualityDmaintenanceMCP server for connecting to Microsoft Fabric and Power BI semantic models, enabling workspace browsing, dataset management, TMSL retrieval, DAX queries, model creation/editing, and includes a Best Practice Analyzer with 71 rules.Last updated2MIT
Related MCP Connectors
Outlook Mail (Microsoft 365) MCP Pack
Outlook Contacts (Microsoft 365) MCP Pack
Official Microsoft MCP Server to query Microsoft Entra data using natural language
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/stembisohlebela/PowerBi-Modelling-Claude-MCP'
If you have feedback or need assistance with the MCP directory API, please join our Discord server