A matrix visual renders slowly; after using Performance Analyzer and DAX Studio, the DAX query runs fast in DAX Studio. What should you do next?

• A. Use Tabular Editor
• B. Clear the Model Cache
• C. Rebuild the Data Model
• D. Increase Cache Size

Answer: (B)

When a matrix visual is slow but the DAX query runs quickly in DAX Studio, the issue is often the model’s cached state. Power BI keeps cached results and query plans to speed up repeated work, but if that cache is stale or bloated, the visual can take longer to render even though the underlying query is fast.

Clearing the model cache forces the engine to rebuild calculations from the current model state, removing stale data and cached plans. After clearing, re-run the visual to verify the performance improves because the engine is now working with fresh calculations.

This is a quick, low-risk first step. Other options like using a different editor, rebuilding the model, or tweaking a cache setting aren’t targeted fixes for this caching issue and are less likely to yield an improvement in this scenario.