Question

A report page in Power BI Desktop is loading slowly for users. Your manager asks you to determine which specific visual on the page is responsible for the delay and whether the bottleneck is the DAX query or the visual rendering. Which tool and approach should you use first?

Accepted Answer

Run Performance Analyzer, interact with the page to record each visual, and review the DAX query and visual display durations for the slowest visual

Answer

Open the DAX query view and manually rewrite every measure to use variables before testing again

Answer

Use Column distribution in Power Query Editor to profile the underlying table cardinality

Answer

Enable bidirectional cross-filtering on all relationships to speed up filter propagation