DP-500 · Question #32
You are optimizing a Power BI data model by using DAX Studio. You need to capture the query events generated by a Power BI Desktop report. What should you use?
The correct answer is C. an All Queries trace. To capture all query events from a Power BI Desktop report using DAX Studio, you should utilize the 'All Queries' trace.
Question
Exhibit
Options
- Athe DMv list
- Ba Query Plan trace
- Can All Queries trace
- Da Server Timings trace
How the community answered
(44 responses)- A2% (1)
- B2% (1)
- C95% (42)
Why each option
To capture all query events from a Power BI Desktop report using DAX Studio, you should utilize the 'All Queries' trace.
The DMVs list provides metadata and server status, but does not actively capture ongoing query events.
A Query Plan trace shows the execution plan for a single, specific DAX query, not all queries generated by the report.
The 'All Queries' trace in DAX Studio is specifically designed to capture every DAX query and related event that Power BI Desktop sends to the underlying Analysis Services data model. This comprehensive trace includes queries generated by visuals, filters, and background processes, making it essential for thorough report optimization.
A Server Timings trace provides detailed timing for a single query, breaking down formula and storage engine time, but it does not capture all queries generated by the report.
Concept tested: DAX Studio tracing features
Source: https://dax.studio/features/tracing/
Topics
Community Discussion
No community discussion yet for this question.
