Using Query Folding to Improve Power BI Performance

Query folding doesn’t get a lot of press, but this unassuming functionality can dramatically improve Power BI performance. Visualizations or reports contain multiple queries that need to be processed and can tax your computational power. If your queries are complex and you’re running dashboards off a laptop, for example, things can bog down when query steps get handled locally instead of back at the data source.

Also called query delegation or predicate push-down, query folding is a way to maximize limited resources by generating a single statement to retrieve and transform source data. The goal of folding is to offload as much of the query heavy lifting and processing back to the source database. It helps you to best optimize what gets sent back to the data source and can also dramatically reduce what is imported into Power Query and processed locally. By understanding the steps of your query, you can make changes that will improve Power BI performance. The best part of query folding is it is built-in and ready for you to use!

Join us for a webinar and demo on query folding. We will go behind the scenes on how Power Query looks at your data. Along with an overview on query evaluation and folding, you’ll learn how to:

  • Know what sources can achieve folding
  • Determine when a query can be folded
  • Understand the icons and indicators of what steps in your queries can be folded
  • Leverage Query Plan to see what’s happening with your queries behind the scenes

Connect with Senturus

Sign up to be notified about our upcoming events

Back to top