Forum Discussion
Live Connection Optimization Techniques
What are the best ways to optimize a live connection report??
My report is very slow. It buffers a lot.
Hi VartikaJha ,
You can optimize your solution at different architectural layers. Layers include:
- The data source
- The data model
- Visualizations, including dashboards, Power BI reports, and Power BI paginated reports
- The environment, including capacities and the network
You can monitor performance to identify bottlenecks. Slow queries—or report visuals—should be a focal point of continued optimization. Monitoring can be done at design time in Power BI Desktop, or on production workloads in Power BI Premium capacities. For more information, see Monitoring report performance in Power BI.
For more details, please refer to:
Optimization guide for Power BI
Microsoft Power BI: My Power BI report is slow. What should I do?
Best Regards,
Jianbo Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
more details please. Is this a shared capacity or Premium? Have you enabled the service cache?
Hi VartikaJha ,
You can optimize your solution at different architectural layers. Layers include:
- The data source
- The data model
- Visualizations, including dashboards, Power BI reports, and Power BI paginated reports
- The environment, including capacities and the network
You can monitor performance to identify bottlenecks. Slow queries—or report visuals—should be a focal point of continued optimization. Monitoring can be done at design time in Power BI Desktop, or on production workloads in Power BI Premium capacities. For more information, see Monitoring report performance in Power BI.
For more details, please refer to:
Optimization guide for Power BI
Microsoft Power BI: My Power BI report is slow. What should I do?
Best Regards,
Jianbo Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
