Performance analyzer durations: DAX query and visual display metrics

PL-300 By islever Editorial Last updated

Optimize model performance

Short answer

BE Performance analyzer shows DAX query and visual display durations for each visual.

Question

You create a Power BI report named Summary1. You discover that Summary1 is slow. You run Performance analyzer to identify performance metrics for Summary1. Which two metrics display the execution duration in Performance analyzer? Each correct answer present part of the solution. NOTE: Each correct answer is worth one point.
  1. Top Operations
  2. DAX query Correct Answer
  3. Server requests
  4. Dependencies
  5. Visual display Correct Answer

Key Takeaways

Per-visual logs in Performance analyzer show duration for two phases: DAX query (time to run the query against the model) and Visual display (time to render the results).

The slow report Summary1 is being profiled with Performance analyzer, and the question asks which two displayed metrics express execution duration.

Common mistake: Confusing the breakdown list with a duration metric — Top Operations enumerates expensive DAX operations inside a query but is an inspection view, not one of the duration figures.

Expert Analysis

Why the Answer Is Correct

Microsoft's Performance analyzer documentation describes each visual's log as recording the time spent (duration) for the DAX query and for the visual display. Those two figures (B and E) directly display execution durations: how long the engine took to answer the visual's query, and how long the browser took to render it.

Why the Other Options Are Wrong

Top operations (A) is a drill-down list of the most expensive operations within a DAX query, used for diagnosis — it names operations and their individual timings but is not itself a duration metric category. Dependencies (D) tracks which other visuals and data triggered a visual's update, not a duration. Together they fail the 'display the execution duration' test that B and E pass.

Community Comment Notes

A commenter quotes the official Performance analyzer page, noting each visual's log includes the durations for DAX query and visual display, which matches B and E. Other comments simply confirm the pair.

Official Reference

https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-performance-analyzer

This link opens the official vendor documentation in a new tab.

Community Votes

BE
100%

100% of anonymous learners picked answer BE. Votes are pick records left by other test-takers — they are not the verified answer.

Discussion 4 contributions

Compiled from public community threads and reader submissions, lightly edited for clarity. Handles and vote tallies are shown as recorded, and comments reflect the views of individual contributors.

From public community threads 4

  1. jaume 👍 2
    DAX query and Visual Display are the metrics available in Performance Analyzer
  2. Odidepse 👍 1
    Dax and Visual Display from https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-performance-analyzer . Excerpt from the link: Each visual's log information includes the time spent (duration) to complete the following categories of tasks: DAX query - If a DAX query was required, this is the time between the visual sending the query and Analysis Services returning the results. Visual display - This is the time required for the visual to draw on the screen, including the time required to retrieve any web images or geocoding. Other - This is the time required by the visual for preparing queries, waiting for other visuals to complete, or performing other background processing. Evaluated parameters (preview) - This is the time spent evaluating the field parameters within a visual. Learn more about field parameters (preview).
  3. Ash_34 👍 3
    Answer is correct!
  4. ChopChop007 👍 1
    Dax Query Visual Display

Reader comments & corrections

No reader corrections yet — spotted an error or have a note? Share it below.

Log in to comment, report an error, or add a note about this question.

Practice All PL-300 Questions

Access 116 questions with complete answers and detailed explanations.

View Full PL-300 Practice Test →

← Back to PL-300 Study Guide