Power BI MCP Server
An MCP (Model Context Protocol) server that lets AI agents manage Power BI workspaces, datasets, and refreshes via natural language.
For refresh incidents, the server brings dataset context, execution errors, same-workspace report dependencies, and optional local PBIP source hints into one evidence bundle. An agent can use it to propose the next investigation step while leaving fixes and operational decisions to the operator.
Walk through a simulated refresh diagnosis, or follow Quick Start to connect your MCP client.
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) |
