Performance Analyzer in Power BI - Step-by-Step Guide

Introduction

Performance Analyzer helps you see how long each visual or query takes to load in your Power BI report. It solves the problem of slow reports by showing which parts need improvement.

When your report pages take too long to load and you want to find the slow visuals

When you want to compare the performance impact of different visuals on the same page

When you add new complex measures and want to check if they slow down your report

When you want to optimize report refresh times by identifying slow queries

When you want to share performance details with developers or report designers

Steps

Step 1: Open

- Power BI Desktop

Your report file is loaded and ready for analysis

Step 2: Click

- View tab on the ribbon

View tab options appear

Step 3: Select

- Performance Analyzer pane button in the View tab

Performance Analyzer pane opens on the right side of the screen

Step 4: Click

- Start Recording button in the Performance Analyzer pane

Performance Analyzer starts capturing the loading times of visuals on the current report page

Step 5: Interact

- Report page (e.g., refresh or click slicers)

Performance Analyzer records the time taken for each visual to refresh or load

Step 6: Click

- Stop Recording button in the Performance Analyzer pane

Recording stops and a list of visuals with their load times appears in the pane

Step 7: Click

- Copy Query button next to a visual in the Performance Analyzer pane

The DAX query for that visual is copied to the clipboard for further analysis

Before vs After

Before

Report page loads without any performance data shown

After

Performance Analyzer pane shows each visual's load time and query details after recording

Settings Reference

Start Recording

📍 Performance Analyzer pane

Begin or end capturing performance data for visuals

Default: Not recording

Copy Query

📍 Performance Analyzer pane next to each visual

Copy the DAX query used by the visual to clipboard

Default: Not copied

Common Mistakes

Not clicking Start Recording before interacting with the report

No performance data is captured if recording is not started

Always click Start Recording in the Performance Analyzer pane before testing visuals

Assuming all slow visuals are caused by complex queries

Some slow visuals may be slow due to large data or visual complexity, not just queries

Use Performance Analyzer data along with data model review to find root causes

Summary

Performance Analyzer helps identify slow visuals and queries in Power BI reports

You must start and stop recording to capture performance data

Copying queries lets you analyze or optimize DAX behind visuals

Practice

1. What is the main purpose of the Performance Analyzer in Power BI?

easy

A. To create new visuals automatically

B. To share reports with other users

C. To clean and transform data before loading

D. To find which visuals or queries are slow in a report

Solution

1. Step 1: Understand Performance Analyzer's role

   Performance Analyzer tracks how long each visual or query takes to run in a report.

2. Step 2: Identify its main use

   It helps find slow parts so you can improve report speed.

3. Final Answer:

   To find which visuals or queries are slow in a report -> Option D

4. Quick Check:

   Performance Analyzer = Find slow visuals [OK]

Hint: Performance Analyzer shows slow visuals to fix [OK]

Common Mistakes:

• Thinking it creates visuals
• Confusing it with data cleaning tools
• Assuming it shares reports

2. Which of the following is the correct way to start recording in Performance Analyzer?

easy

A. Click 'Start Recording' button before interacting with visuals

B. Right-click on a visual and select 'Record Performance'

C. Open the Data view and click 'Record'

D. Use the DAX formula ANALYZE() in a measure

Solution

1. Step 1: Recall Performance Analyzer usage

   You start recording by clicking the 'Start Recording' button in the Performance Analyzer pane.

2. Step 2: Check other options

   Right-click menus or DAX formulas do not start recording; Data view is unrelated.

3. Final Answer:

   Click 'Start Recording' button before interacting with visuals -> Option A

4. Quick Check:

   Start Recording button = Begin analysis [OK]

Hint: Always click 'Start Recording' first in Performance Analyzer [OK]

Common Mistakes:

• Trying to record from right-click menu
• Looking for recording in Data view
• Using DAX formulas to record

3. You used Performance Analyzer and saw these timings for a visual:
Query Duration: 1200 ms
Visual Display: 300 ms
What is the total time taken to render this visual?

medium

A. 1500 ms

B. 900 ms

C. 1200 ms

D. 300 ms

Solution

1. Step 1: Understand timing components

   Total time = Query Duration + Visual Display time.

2. Step 2: Add the times

   1200 ms + 300 ms = 1500 ms total.

3. Final Answer:

   1500 ms -> Option A

4. Quick Check:

   1200 + 300 = 1500 ms [OK]

Hint: Add query and display times for total visual time [OK]

Common Mistakes:

• Using only query duration
• Using only visual display time
• Subtracting times instead of adding

4. You started Performance Analyzer but it shows zero time for all visuals even after interacting. What is the likely problem?

medium

A. You need to refresh the data source first

B. Your report has no visuals

C. You forgot to click 'Start Recording' before testing

D. Performance Analyzer only works in Power Query Editor

Solution

1. Step 1: Check recording status

   If no times appear, recording was likely not started.

2. Step 2: Evaluate other options

   Reports always have visuals; Performance Analyzer works in report view; refreshing data is unrelated.

3. Final Answer:

   You forgot to click 'Start Recording' before testing -> Option C

4. Quick Check:

   No recording = zero times [OK]

Hint: Always start recording before interacting with visuals [OK]

Common Mistakes:

• Assuming no visuals means no data
• Thinking it works in Power Query Editor
• Believing data refresh affects Performance Analyzer

5. You notice a visual takes 5000 ms to load, mostly in 'DAX Query' time. What is the best way to improve performance using Performance Analyzer insights?

hard

A. Disable Performance Analyzer to speed up visuals

B. Optimize the DAX measure or reduce data complexity

C. Increase the report page size to load faster

D. Add more visuals to balance the load

Solution

1. Step 1: Interpret DAX Query time meaning

   High DAX Query time means the measure or data model is slow.

2. Step 2: Choose optimization approach

   Improving DAX formulas or simplifying data reduces query time and speeds visuals.

3. Step 3: Evaluate other options

   Increasing page size or adding visuals won't help; disabling Performance Analyzer doesn't affect performance.

4. Final Answer:

   Optimize the DAX measure or reduce data complexity -> Option B

5. Quick Check:

   High DAX time = optimize DAX [OK]

Hint: Fix slow DAX queries to speed visuals [OK]

Common Mistakes:

• Thinking more visuals improve speed
• Disabling Performance Analyzer helps performance
• Changing page size affects query time