Chapter 10: Implementing Query Diagnostics

Every transformation and data preparation step that you do has an impact on your performance when you develop Power Query transformations. You can analyze and test your queries to observe the consequences while refreshing your data and iteratively applying Power Query steps in Power BI Desktop.

In this chapter, we will see how to best use a built-in feature called Query Diagnostics, in order to easily retrieve relevant data on Power Query performance. In particular, we will go through the following recipes:

  • Exploring diagnostics options
  • Managing a diagnostics session
  • Designing a report with diagnostics results
  • Using Diagnose as a Power Query step

Technical requirements

For this chapter, you will be ...

Get Power Query Cookbook now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.