check_report_data_consistency
Reconcile expected or source-file KPIs against a live Power BI dataset, flag discrepancies beyond tolerance, and return per-KPI consistency details.
Instructions
Reconcile expected or source-file KPIs against a live Power BI dataset.
Args: workspace_id: Power BI / Fabric workspace GUID. dataset_id: Power BI / Fabric dataset GUID. source_path: Optional Excel/CSV source file for independent baseline calculation. sheet_name: Optional Excel worksheet name. catalog_path: Optional YAML KPI catalog path. expected_kpis: Optional dict (or JSON string) of explicit expected KPI numbers. tolerance_pct: Allowed relative discrepancy ratio before flagging mismatch (default 0.001). as_of_date: Optional ISO date YYYY-MM-DD for source baseline calculation. query_executor: Optional injected DAX query executor callable for testing. fabric_client: Optional injected FabricClient for testing. auth_mode: Optional auth mode override. tenant_id: Optional Entra ID tenant. client_id: Optional Entra ID client ID.
Returns: Dict with overall consistency flag and per-KPI source vs dataset discrepancy details.
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": "check_report_data_consistency"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| auth_mode | No | ||
| client_id | No | ||
| tenant_id | No | ||
| as_of_date | No | ||
| dataset_id | Yes | ||
| sheet_name | No | ||
| source_path | No | ||
| catalog_path | No | ||
| workspace_id | Yes | ||
| expected_kpis | No | ||
| fabric_client | No | ||
| tolerance_pct | No | ||
| query_executor | No |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||