DP-500 Question #126: Real Exam Question with Answer & Explanation

Question

What should the team do first?

Options

• AUse Performance analyzer in Power BI Desktop to get the DAX durations.
• BUse DAX Studio to get detailed statistics on the server timings.
• CUse DAX Studio to review the Vertipaq Analyzer metrics.
• DUse Tabular Editor to create calculation groups.

Explanation

To begin optimizing a Power BI report's performance, the team should first use the Performance analyzer in Power BI Desktop to identify the specific visuals and DAX queries that are taking the longest to render or execute.

Common mistakes.

• B. While DAX Studio can provide detailed statistics, including server timings, for specific DAX queries, Performance analyzer is better as an initial high-level overview within Power BI Desktop to identify which queries or visuals are problematic before using DAX Studio for deeper dives.
• C. VertiPaq Analyzer metrics, accessible via DAX Studio, are crucial for optimizing data model size and memory usage, but they are not the first step to identify visual or query execution time bottlenecks.
• D. Tabular Editor is used for advanced data model development, such as creating calculation groups, which is an optimization technique, not an initial diagnostic tool for performance bottlenecks.

Concept tested. Power BI report performance diagnosis

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

No community discussion yet for this question.