BenchMark Quizzes by MDFT Pro

Log Power Query Transformation Durations In Power BI

You are authoring a new report in Power BI Desktop at MDFT Pro. A visual using a specific table is slow, and you need to investigate the performance of Power Query transformations.

You need to log the duration of each step during Power Query transformations for this table. Which tool should you use to analyze the transformation process?

Choose the correct answer from the options below.

Explanations for each answer:

Session Diagnostics in Query Diagnostics is correct. Session Diagnostics records how Power BI interacts with your data source during Power Query transformations, including step durations.
Step Diagnostics in Query Diagnostics is incorrect. Step Diagnostics evaluates a single step, not the entire session.
Performance Analyzer is incorrect. Performance Analyzer is for analyzing report visuals, not Power Query transformations.
Data profiling tools is incorrect. Data profiling tools preview data quality, not transformation durations.

Learn more about Query Diagnostics in Power BI:

Power BI Query Diagnostics

Exam Preparation Quiz

Log Power Query Transformation Durations In Power BI