pbi_diagnose
Diagnose Power BI dataset refresh failures by analyzing metadata, refresh details, and error patterns to identify root causes and suggest next actions.
Instructions
One-shot diagnostic report for a Power BI dataset refresh failure.
Pipeline:
Pull dataset metadata + datasources + gateways + schedule + impacted reports.
Pick a refresh to analyze: explicit refresh_id, OR latest Failed ViaEnhancedApi refresh.
Fetch refresh execution details (messages, objects, attempts).
Classify error: root cause table/partition, error code, underlying pattern, next actions.
Add PBIP source code locate hint (folder path, expressions.tmdl, table file).
Args: workspace_id: The workspace (group) ID. dataset_id: The dataset ID. refresh_id: Optional specific refresh requestId. If omitted, auto-picks latest failed Enhanced refresh.
Returns: Structured JSON diagnostic report.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| workspace_id | Yes | ||
| dataset_id | Yes | ||
| refresh_id | No |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |