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

You have a Power BI report named Report1. Report1 is connected to an imported dataset that contains a matrix. The matrix displays five measures.

When users view the report, they discover that the matrix is slow to render.

You need to review the execution times and durations in the formula engine and the storage engine for the DAX query executed by the matrix.

What should you use?

Answer options

• A. DAX Studio
• B. SQL Server Profiler
• C. Performance analyzer
• D. Vertipaq Analyzer

Correct answer: A

Explanation

The correct answer is DAX Studio, which is specifically designed to analyze DAX queries and provides detailed insights into execution times. SQL Server Profiler is more suited for SQL queries rather than DAX, while Performance Analyzer is helpful for measuring overall report performance but does not provide the detailed execution time metrics for DAX queries. Vertipaq Analyzer focuses on data model optimization rather than query execution metrics.