Query folding to improve Power Query /BI performance
Query Folding allows Power Query to push some of the transformations back to the database and that way query and return the data more efficiently.
Let’s go into more detail in this video:
Watch the tutorial:

Links to the mentioned resources
Other important links:
https://www.mssqltips.com/sqlservertip/3635/query-folding-in-power-query-to-improve-performance/ Chris Webb blog:
https://blog.crossjoin.co.uk/2017/06/11/query-folding-and-writing-your-own-sql-queries-in-power-querypower-biexcel-get-transform/
Was this helpful?
Reader Interactions