How to find the .trc file of generated queries?

[Anonymous]

Hi 

I am trying to find generated native queries by PowerBI, I have a report currently build on a dataset

and I have enable the "trace" feature from Diagnostic option, however when I go to 

    C:\Users\username\AppData\Local\Microsoft\Power BI Desktop

I couldn't find related .trc file. 

Is there a straight way to review power bi generated (native) query?

Thanks

[v-alq-msft]

Hi, @Anonymous 

If your data sources support query folding, you may use 'View Native Query' option to review power bi generated native query.

In the Power Query Editor window, it is possible to determine when a Power Query query can be folded. In the Query Settings pane, when you right-click the last applied step, if the View Native Query option is enabled (not greyed out), then the entire query can be folded.

The View Native Query option is only available for certain relational DB/SQL generating connectors. It doesn't work for OData based connectors, for example, even though there is folding occurring on the backend. The Query Diagnostics feature is the best way to see what folding has occurred for non-SQL connectors (although the steps that fold aren't explicitly called out—you just see the resulting URL that was generated).

For further information, I'd like to suggest you refer to the document .

Best Regards

Allan

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin]

Use DAX Studio to see the actual queries, including Query Plan and Server Timings.