Query folding with Amazon Web Services

Hi 101Mathew,

 

You could check if Query Folding is active by checking for the existence of Native Query code inside that step.

When you use Power Query, the steps you produce are listed in the right side “applied steps” panel, right-click on one of the query steps and then select “view Native Query”. If you are able to do this, ie if view Native Query is enabled, it means Power Query has successfully performed query folding. 

 

Reference:

How do I Know if Query Folding is Active?

Query Folding And Writing Your Own SQL Queries In Power Query/Power BI/Excel Get & Transform

 

Best regards,

Yuliana Gu