Performance Analyzer In Power BI

• In this article, we can learn about the performance analyzer in Power BI.

PERFORMANCE ANALYZER

• The Performance Analyzer helps us to understand how the performance of the dashboard can be optimized.
• Performance Analyzer is an easy and accessible way to track the performance of a Power BI report during the development process in Power BI Desktop.
• Here we analyze the report. We can execute the operation in the following way

→ Open pbix File.

→ Enable Performance Analyzer.

→ Start Recording.

• We go to the view tab and simply check the Performance Analyzer option.

VIEW TAB

• When we enable the Performance Analyzer option then a new window is open inside the Visualization tab.
• After that click on the Start Recording button.

RECORDING

• Then click on the refresh visuals button.
• The Performance Analyzer captures the Duration time in milliseconds for each visual on the page.

• Again click on the Refresh visuals button in the Performance Analyzer pane.
• After refreshing we see the duration of the visuals for the second execution. The execution time of every visual has been reduced since the first execution.

DETAILS OF VISUALS

• Performance Analyzer gets all details of all components in the dashboard.

PERFORMANCE ANALYZER

• The performance analysis is done on three parameters:

1. DAX Query:- The length of time it takes for Analysis Service to run the query.
2. Visual Display:- How long it takes for the visual to draw them on the screen (including anything like retrieving web images or geocoding).
3. Other:- Covering Background Processing like Preparing Queries, Fetching result sets.

• We can get more detail of component analysis we have the option Copy query which we can paste on a notepad or export the report in JSON format using the Export Option.

PERFORMANCE ANALYZER

• We can review the DAX code to see if any changes can be done to optimize the performance of the dashboard.

COPY QUERY

• If we need to data for future analysis the Export option provides the opportunity to save the data in a JSON format.

EXPORT DATA

• When we switch the first page to another page while analyzes the performance then the Performance analyzer gets both pages component.

CHANGE PAGE

If you are new to Power BI start with the following must-watch video:-