Power Query diagnostics doesn't show the correct 'Query' data

[dterrienpro]

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": "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

[Anonymous]

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

[dterrienpro]

Hello @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