DP-600 - Implement and Manage Semantic Models - Section 3.5

Implement performance improvements in queries and report visuals and improve DAX performance for enterprise-scale semantic models.

Use Performance Analyzer and DAX optimisation techniques to identify slow visuals and rewrite inefficient measures, targeting the VertiPaq engine's columnar storage strengths. Configure aggregations and query reduction settings to reduce the number of queries sent to DirectQuery sources and improve report responsiveness.

Performance AnalyzerDAX optimisationaggregationsquery reductionVertiPaq engine

More in this domain

Back to all Implement and Manage Semantic Models objectives, or the DP-600 cert hub.

Examworthy is not affiliated with or endorsed by Microsoft. Original, blueprint-aligned practice material only.