Courses / Power Query (Get & Transform)
41. Query Folding
Understanding query folding and why pushing operations to the data source improves performance when supported.
Power Query M
Query Folding
Query folding is Power Query's ability to translate transformation steps into native source queries so the source does the heavy work.
"I want the database to do the heavy lifting instead of Excel pulling everything and doing it on my laptop."
Query folding is when Power Query converts your applied steps (filters, joins, aggregations) into source-native operations (SQL, OData) so the data source performs them, improving speed and reducing network load.
"I want the database to do the heavy lifting instead of Excel pulling everything and doing it on my laptop."
Query folding is when Power Query converts your applied steps (filters, joins, aggregations) into source-native operations (SQL, OData) so the data source performs them, improving speed and reducing network load.