Forum Discussion
Report loading time is increased
The reports work fine on some days because Databricks load and cluster performance can vary daily. If fewer jobs or users are active, the cluster handles queries faster. On busy days, it slows down.
Check Databricks job and user load during slow times
Enable auto-scaling or increase cluster size
Optimise model and use query caching in Power BI
Prefer scheduled refresh over live connection if delay is frequent
Hi yogita_2025 ,
The slow report loading you’re experiencing during specific hours is most likely due to high resource usage or workload spikes on the Databricks cluster your semantic model connects to. Since your Power BI reports rely on a live connection, any increase in concurrent jobs, user activity, or scheduled processes on Databricks during that time can delay query responses and impact report performance. To address this, it’s recommended to monitor Databricks cluster usage during the affected hours to identify bottlenecks, and consider enabling auto-scaling or increasing cluster size temporarily to handle peak loads.
On the Power BI side, using tools like Performance Analyzer can help pinpoint visuals or queries causing delays, while implementing optimizations such as aggregations, incremental refresh, or switching to import mode can significantly reduce query load and improve performance. If you are using Fabric (Premium) capacity, the Metrics app can also offer valuable insights into usage patterns and help diagnose service-level issues. Combining improvements in both your data source and report design should help stabilize and enhance the loading experience.