Performance analyzer durations: DAX query and visual display metrics

Optimize model performance
Answer Correct answer: B, E — Performance analyzer shows DAX query and visual display durations for each visual.

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

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.

Community Insight

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.

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.

Community Discussion (4 comments)

Odidepse 👍 1 Selected: BE
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).
jaume 👍 2 Selected: BE
DAX query and Visual Display are the metrics available in Performance Analyzer
ChopChop007 👍 1 Selected: BE
Dax Query Visual Display
Ash_34 👍 3 Selected: BE
Answer is correct!

Comments & Corrections

No comments 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.

Submitted for moderation before publishing. Keep it helpful and respectful.

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

Related Analysis

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