✏️ Explanatory Question

A report that previously loaded in 3 seconds now takes 45 seconds. How would you troubleshoot it?

👁 2 Views
📘 Detailed Answer
🟢 Easy
💡

Answer with Explanation

Troubleshooting Steps:

  1. Review recent model changes.
  2. Analyze DAX queries.
  3. Use Performance Analyzer.
  4. Review relationships.
  5. Check DirectQuery sources.
  6. Validate refresh history.
  7. Review visual complexity.
  8. Optimize bottlenecks.

This systematic approach helps identify the root cause efficiently.