Chapter 6: Optimizing Power Query Performance
Once you become more confident with Power Query and are able to do the main transformations and reshape your data, you are ready to focus on optimizing queries' performance. This topic is important because when you prepare data for reporting or any other further use and you need to refresh data or to retrieve subsets of filtered data, you need to think about and design Power Query steps in a way that helps you to avoid slow queries and suboptimal performance for end users. In this chapter, we will learn how to use concepts such as parameters and query folding that can help you improve queries' loading times.
In particular, you will explore the following performance optimization options within Power Query:
- Setting up parameters
- Filtering with parameters
- Folding queries
- Leveraging incremental refresh and folding
- Disabling query load
