Learning about the performance analyzer
The performance analyzer is an excellent tool for analyzing the reports in a pbix file. In this section, we will spend some time learning about its features. We will also learn when and how to use the tool to diagnose performance problems.
The performance analyzer lets you record user actions and break down report behavior by each report visual, including DAX and DirectQuery queries. The tool provides durations for phases of a report visual’s internal operations, in milliseconds. The following screenshot shows how the Performance analyzer pane displays statistics for a single-page refresh operation that’s initiated from the tool itself.
Figure 3.5 – Performance analyzer results with an expanded visual
Take note of the action that’s been captured, and the duration breakdowns provided. The Copy query functionality is especially useful when you’re debugging performance related to...
