Ready to curb your Power BI skills? Find out more here!
Welcome to our Knowledge Base

Tip: Start typing in the input box for immediate search results.

Print

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:

Query folding to improve Power BI performance

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

Let us know your thoughts...

Table of Contents