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.
Tool call template
Replace each placeholder with a value matching the input schema. Only required parameters are included; add optional parameters as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {
"workspace_id": "<workspace_id>",
"dataset_id": "<dataset_id>"
},
"name": "pbi_diagnose"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| workspace_id | Yes | ||
| dataset_id | Yes | ||
| refresh_id | No |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |