QuestionQ110

VerifiedMaintain a data analytics solution

You have a Fabric tenant containing a Microsoft Power BI report named Report1.

Report1 is slow to render, and you suspect an inefficient DAX query is being run.

Identify the slowest DAX query and review the time it spends in the formula engine compared with the storage engine.

Which five actions should you take, in sequence?

Drag & Drop
Explanation

Power BI Performance Analyzer records visual-load operations and includes a DAX query duration for each visual; sorting by that duration identifies the slowest DAX query. DAX Studio Server Timings reports total server processing time and splits it into Formula Engine (FE) and Storage Engine (SE) time, enabling the required engine comparison.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!