MicrosoftMicrosoft
DP-500 · Question #75
DP-500 Question #75: Real Exam Question with Answer & Explanation
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.
Query and transform data
Question
You need to identify the root cause of the data refresh issue. What should you use?
Options
- Athe Usage Metrics Report in powerbi.com
- BQuery Diagnostics in Power Query Editor
- CPerformance analyzer in Power BI Desktop
- D
Explanation
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.
Common mistakes.
- A. 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.
- C. 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.
- D. This option is empty and thus not a valid choice.
Concept tested. Power Query Diagnostics for refresh issues
Reference. https://learn.microsoft.com/en-us/power-query/querydiagnostics
Topics
#Query Diagnostics#Data Refresh#Troubleshooting#Power Query
Community Discussion
No community discussion yet for this question.