Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

0

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

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 :

dterrienpro_0-1675792692459.png

    {

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

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

Comments
v-xiaoyan-msft
Community Support
Status changed to: Delivered

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
Frequent Visitor

Hello @v-xiaoyan-msft ,

 

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-da...

 

Regards