New JSON theme available! Check it out here!
How can we help?

Welcome to Curbal Learning Portal. Search for answers using the search box below,
or create a request for a video or blog if you cannot find your answer.

Popular searches: DAX Glossary | Guided courses | Request a video

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?
Previous File to analyze json file from the Performance Analyzer in Power BI – Part 2
Next Flat tables or models in Power BI? Which one should I choose and why?

Reader Interactions

Let us know your thoughts...

Table of Contents