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 "Deploy 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 deployed
Maintenance
ActivityStale
ResponsivenessNo issues
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 gradedqualityDmaintenanceMCP server for Power BI — local PBIX file analysis, cloud API operations, report export, and semantic model extraction from Power BI Desktop.35 npm1MIT
- 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