Power BI MCP Server
An MCP (Model Context Protocol) server that lets AI agents manage Power BI workspaces, datasets, and refreshes via natural language.
Features
Authentication & Discovery
| Tool | Description |
|---|---|
pbi_auth |
Authenticate via Azure AD device code flow (with token caching & auto-refresh) |
pbi_list_workspaces |
List accessible workspaces (with optional name filter) |
pbi_list_datasets |
List datasets in a workspace |
Dataset & Refresh Management
| Tool | Description |
|---|---|
pbi_dataset_info |
Aggregate dataset metadata + datasources + gateways + refresh schedule + impacted reports + PBIP locate (single call) |
pbi_refresh_dataset |
Trigger an Enhanced refresh (supports table-level, polling, retry, timeout) |
pbi_refresh_manage |
Refresh lifecycle: view history (status), get execution details (details), or cancel (cancel) |
Diagnostics & Source Code
| Tool | Description |
|---|---|
pbi_diagnose |
One-shot diagnostic report for refresh failures — root cause classification, error catalog, next actions, PBIP source hints |
pbi_locate_pbip |
Locate PBIP source code for a dataset (fuzzy folder match + optional table TMDL & M source extraction) |
