Performance Analyzer in Power BI - Cheat Sheet & Quick Revision

Recall & Review

beginner

What is the purpose of the Performance Analyzer in Power BI?

Performance Analyzer helps you see how long each visual or query takes to run. It helps find slow parts so you can make your report faster.

beginner

Name the three main steps Performance Analyzer breaks down for each visual.

1. DAX Query: Time to run the data query.
2. Visual Display: Time to draw the visual.
3. Other: Time for other tasks like data formatting.

beginner

How do you start recording performance in Power BI using Performance Analyzer?

Open Performance Analyzer pane and click 'Start Recording'. Then interact with your report to capture timings.

intermediate

Why is it helpful to export Performance Analyzer results?

Exporting lets you save the timings as a JSON file. You can share it with others or analyze it later to improve report speed.

intermediate

What common actions can improve report speed after using Performance Analyzer?

Actions include optimizing DAX formulas, reducing visuals on a page, and simplifying data models.

What does Performance Analyzer NOT measure in Power BI?

A Time taken to export data to Excel

B Time taken by DAX queries to run

C Time taken by each visual to render

D Time taken for other visual tasks

Performance Analyzer measures visual rendering, DAX query time, and other tasks, but it does not measure export times.

How do you access Performance Analyzer in Power BI Desktop?

A From the View tab

B From the Home tab

C From the Modeling tab

D From the Data tab

Performance Analyzer is found under the View tab in Power BI Desktop.

Which step should you do first to analyze report performance?

A Optimize DAX formulas

B Export results

C Start recording in Performance Analyzer

D Delete visuals

You start by recording performance to see where delays happen before making changes.

What file format does Performance Analyzer export its results as?

A .csv

B .json

C .txt

D .xlsx

Performance Analyzer exports results as a JSON file.

Which of these is a common cause of slow report performance detected by Performance Analyzer?

A Using bookmarks

B Adding titles to visuals

C Using slicers

D Too many visuals on a page

Having many visuals on a page can slow down report rendering.

Explain how to use Performance Analyzer to find slow visuals in a Power BI report.

Think about the steps from opening the tool to reading the results.

Describe three ways to improve report speed after analyzing with Performance Analyzer.

Focus on common performance fixes in Power BI.

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