On Power BI Desktop 2022/12, Diagnostics_Detailed... file shows events not related to the displayed query
Example 1 : 'Source type' is a parameter with a list of values. There is no reason why it reads a file. The file is read by another query :
"Id": "26.23",
"Query": "Source type",
"Step": null,
"Category": "Data Source",
"DataSourceKind": "File",
"Operation": "Read file",
"StartTime": "2023-02-07T16:55:08.4117781Z",
"EndTime": "2023-02-07T16:55:08.4124241Z",
"ExclusiveDurationPct": 8.8193431951156132E-05,
"ExclusiveDuration": "00:00:00.0006460",
"Resource": "c:\\users\\username\\documents\\ep alignment tool.txt",
"DataSourceQuery": null,
"AdditionalInfo": null,
"RowCount": null,
"ContentLength": null,
"IsUserQuery": false,
"Path": "0/1/8",
"GroupId": 3,
"PartitionKey": null,
"Process": "Engine (22076/1)",
"ActivityId": "0d8e3901-6ab9-4353-bdd2-d09a91808854",
"DataSourceOperationIds": null
},
Example 2 : when running query diagnostics on a full refresh for the second time, null queries appear in events. The first time the refresh is done 'Query' is never null
{
"Id": "44.93",
"Query": null,
"Step": null,
"Category": "Evaluator",
"DataSourceKind": null,
"Operation": "Service: OnBeginGetResult",
"StartTime": "2023-02-02T12:21:39.7349735Z",
"EndTime": "2023-02-02T12:21:56.8075415Z",
"ExclusiveDurationPct": 0.00023446860872821816,
"ExclusiveDuration": "00:00:00.0040220",
"Resource": null,
"DataSourceQuery": null,
"AdditionalInfo": null,
"RowCount": null,
"ContentLength": null,
"IsUserQuery": null,
"Path": "0/3",
"GroupId": 2,
"PartitionKey": null,
"Process": "Engine (18144/1)",
"ActivityId": "90016729-67f7-4d2b-a03c-5176a36a3e99",
"DataSourceOperationIds": null
},
Thanks in advance
Regards
Hi @dterrienpro ,
Whenever you start diagnostics, Power Query begins tracing any evaluations that you cause. The evaluation that most users think of is when you press refresh, or when you retrieve data for the first time, but there are many actions that can cause evaluations, depending on the connector.
Query Diagnostics - Power Query | Microsoft Learn
Best regards.
Community Support Team_ Caitlyn