For the last chapter in this book, we are going to look at some of the techniques and tools you can use to analyze DAX query performance and identify potential problems.
We will start this chapter by learning about the storage engine and the formula engine. These are the two engines that are used to resolve DAX queries. We'll look at how these engines work together to retrieve data from the data model and return a result. We'll also learn how this knowledge can help to identify and resolve performance issues with DAX queries.
We will then look at some of the tools we can use to investigate the performance of DAX queries. These include DAX Studio, the SQL Server Profiler, and the Performance Analyzer feature in Power BI Desktop. We'll learn how to use these tools and how they can help to find potential bottlenecks and performance issues...