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
Thankyou, BhavinVyas3003, for your response.
Hi yogita_2025,
We appreciate your inquiry on the Microsoft Fabric Community Forum.
Based on my understanding, the intermittent slowness experienced during specific time periods may be attributed to factors such as the data source, model design, or activities at the service level.
Kindly consider the following optimisation steps, which might help in resolving the issue:
- Use the Performance Analyzer in Power BI Desktop to identify which visuals or queries contribute most to report slowness during the affected time frames.
- Enable Query Diagnostics in Power BI Service to pinpoint delays in report queries and ascertain whether the bottleneck lies within Power BI or the data source (Databricks).
- For large datasets, perform pre-aggregation at the model level to reduce the overhead of real-time queries.
- Use Incremental Refresh for large tables to reduce data load times and significantly improve query performance.
- If your workspace is hosted in a Fabric (Premium) capacity, utilise the Metrics app to monitor query duration and capacity usage during periods of slowness.
- Optimise the model and relationships by removing unused columns and tables. Adopt a star schema design and minimise high-cardinality columns.
If you find this response helpful, kindly mark it as the accepted solution and provide kudos. This will assist other community members facing similar issues.
Should you have any further queries, please feel free to contact the Microsoft Fabric Community.
Thank you.