DP-500 · Question #75
You need to identify the root cause of the data refresh issue. What should you use?
The correct answer is B. Query Diagnostics in Power Query Editor. To diagnose the root cause of data refresh issues, use Query Diagnostics in Power Query Editor to inspect the M query execution steps and identify bottlenecks or errors.
Question
Options
- Athe Usage Metrics Report in powerbi.com
- BQuery Diagnostics in Power Query Editor
- CPerformance analyzer in Power BI Desktop
- D
How the community answered
(44 responses)- A14% (6)
- B80% (35)
- C2% (1)
- D5% (2)
Why each option
To diagnose the root cause of data refresh issues, use Query Diagnostics in Power Query Editor to inspect the M query execution steps and identify bottlenecks or errors.
The Usage Metrics Report provides information about report consumption and performance from a user perspective, but it does not offer details about the underlying data refresh process or M query execution.
Query Diagnostics in Power Query Editor provides detailed insights into how Power Query processes data, including the duration of each transformation step and any errors encountered during refresh, which is invaluable for identifying the specific cause of a refresh issue.
Performance analyzer in Power BI Desktop helps analyze the rendering performance of visuals and DAX queries within a report, not the data refresh process itself.
This option is empty and thus not a valid choice.
Concept tested: Power Query Diagnostics for refresh issues
Source: https://learn.microsoft.com/en-us/power-query/querydiagnostics
Topics
Community Discussion
No community discussion yet for this question.