Designing and Implementing Enterprise-Scale Analytics Using Microsoft Azure and Power BI — Question 57

You discover a poorly performing measure in a Power BI data model.
You need to review the query plan to analyze the amount of time spent in the storage engine and the formula engine.
What should you use?

Answer options

• A. Tabular Editor
• B. Vertipaq Analyzer
• C. DAX Studio
• D. Performance analyzer in Power BI Desktop

Correct answer: C

Explanation

DAX Studio is the appropriate tool for analyzing query performance in Power BI as it allows for detailed examination of the query plan. While the other options provide useful features, they do not focus specifically on reviewing the query plan and timing for both engines as effectively as DAX Studio does.