Performance Analyzer in Power BI - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to start the Performance Analyzer in Power BI Desktop.

Power BI

Go to the View tab and click on [1] to open the Performance Analyzer pane.

Drag options to blanks, or click blank then click option'

AData view

BFilters

CBookmarks

DPerformance Analyzer

Attempts:

3 left

💡 Hint

Common Mistakes

Choosing 'Data view' instead of 'Performance Analyzer'.

Selecting 'Bookmarks' which is unrelated to performance.

To start Performance Analyzer, you must open it from the View tab by clicking on 'Performance Analyzer'.

2fill in blank

medium

Complete the code to record the performance of visuals in Power BI.

Power BI

In the Performance Analyzer pane, click on [1] to start capturing the performance data.

Drag options to blanks, or click blank then click option'

AExport

BClear All

CStart Recording

DRefresh

Attempts:

3 left

💡 Hint

Common Mistakes

Clicking 'Clear All' which deletes previous data.

Clicking 'Export' before recording any data.

Clicking 'Start Recording' begins capturing the performance data of report visuals.

3fill in blank

hard

Fix the error in the description of Performance Analyzer's output.

Power BI

Performance Analyzer shows the [1] time for each visual, including DAX query, visual display, and [2] time.

Drag options to blanks, or click blank then click option'

Aload

Brefresh

Crender

Dexport

Attempts:

3 left

💡 Hint

Common Mistakes

Using 'load' or 'refresh' which are not specific to visual drawing.

Using 'export' which is unrelated.

The correct term is 'render time', which is the time taken to draw the visual on screen.

4fill in blank

hard

Fill both blanks to export the performance data as a JSON file.

Power BI

After recording, click on [1] and then select [2] to save the data.

Drag options to blanks, or click blank then click option'

AExport

BClear All

CExport as JSON

DStart Recording

Attempts:

3 left

💡 Hint

Common Mistakes

Clicking 'Clear All' which deletes data instead of exporting.

Selecting 'Start Recording' which begins new capture.

You must click 'Export' and then choose 'Export as JSON' to save the performance data.

5fill in blank

hard

Fill all three blanks to analyze a slow visual's performance using Performance Analyzer.

Power BI

First, [1] recording, then [2] the slow visual, and finally [3] the results in the pane.

Drag options to blanks, or click blank then click option'

Astart

Brefresh

Creview

Dstop

Attempts:

3 left

💡 Hint

Common Mistakes

Stopping recording before refreshing the visual.

Not refreshing the visual to capture performance.

You start recording, refresh the visual to capture its performance, then stop recording to see the results.

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