Hello,
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": "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
},
2 Comments
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_ CaitlynHello Anonymous ,
Thanks for your reply. Sorry to insist, I feel there's a bug. There are quite a lot of inconsistencies between Json data and queries.
Chris web mentionned in 2020 : [Note: You may find that some query evaluations have nulls instead of the name of the query; that’s an issue with the diagnostics data that will be addressed soon] : https://blog.crossjoin.co.uk/2020/02/10/an-m-function-to-help-you-explore-power-query-diagnostics-data/
Regards
