In the last chapter of this book, we looked at some of the techniques and tools that are used to help with analyzing the performance of DAX queries and identify potential problems.
We started off this chapter by learning about the storage and formula engines, the two engines used to process a DAX query. We looked at how they work together to retrieve data from the data model, and then process that data to return a result. We learned about how the logical and physical query plans produced by these query engines can help to identify and resolve performance issues with DAX queries.
Finally, we looked at some tools to help us to investigate the performance of DAX queries. We looked at DAX Studio, SQL Server Profiler, and the Performance Analyzer feature in Power BI Desktop. We learned about using these tools to monitor performance by looking at the output of the query engines...
