Forum Discussion

yogita_2025's avatar
yogita_2025
Regular Visitor
1 year ago
Solved

Report loading time is increased

Hi,    I have published my reports on client's workspace. The reports are using a semantic model in that workspace for as dataset. The semantic model is connected to databricks. I have noticed that...
Need Help
  • BhavinVyas3003's avatar
    BhavinVyas3003
    1 year ago

    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

BhavinVyas3003's avatar
BhavinVyas3003
Super User
1 year ago

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