A
licenseC
qualityB
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
1
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.
Tool Schema Changelog
Recent tool additions, removals, and schema changes observed during successful MCP inspections. Dates show when Glama detected each change.
No tool schema history has been recorded yet.
This server cannot be installed
Maintenance
ActivityStale
ResponsivenessNo issues
Resources
Unclaimed servers have limited discoverability.
Looking for Admin?
If you are the server author, to access and configure the admin panel.
Related MCP Connectors
OneDrive (Microsoft Graph) MCP Pack
Generate, edit, merge, translate and PDF-convert PowerPoint (.pptx) over MCP. 8 tools.
- BasedashOAuthcom.basedash
Governed BI MCP. Ask questions of live company data and list workspace sources via OAuth.
Related MCP Servers
- AlicenseNot gradedqualityAmaintenanceMCP 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.17MIT
- AlicenseNot gradedqualityCmaintenanceMCP server for Power BI — local PBIX file analysis, cloud API operations, report export, and semantic model extraction from Power BI Desktop.471MIT
- AlicenseNot gradedqualityDmaintenanceMCP 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.2MIT
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