Power BI Power query - check if query is folded

[tomas12344]

Hi All

Customer is using SAP BW Connector to download data in import mode to PBI. This proces is quite long and we need to check, if the query is folded to SAP native query.

Have checked in Power Query editor, that native query is available and could be displayed and also in the top left corner (of the previe table) the flag is that the query should be folded.

The question is, what is the best way to confirm that the query is folded? (the colleagues form the customer dont know where to find the logs from SAP, and i'm not familiar with SAP).

Have used the diagnostic tool in power query editor, where i found some row with Query Execution and query in the Data Source Query column. Is this sufficient for control of the folding?

What about SQL Profiler? Which event to look for in the trace?

Or is there any other tool?

thank you

[v-yalanwu-msft · Accepted solution]

Hi, @tomas12344 ;

Then you can use the second method to see if View Native Query is grayed out.

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-yalanwu-msft]

Hi, @tomas12344 ;

You could Go by looking for the indicator light.
Query folding indicators use an underlying query plan, and require it to be able to get information about the query to report it. Currently the query plan only supports tables, so some cases (lists, records, primitives) won't report as folding or not. Similarly, constant tables report as opaque.

Query folding indicators in Power Query - Power Query | Microsoft Learn

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[tomas12344]

@v-yalanwu-msft 

thank you for answer, but currently i dont use Power Query online, only Desktop.