Live Connection Optimization Techniques

[VartikaJha]

What are the best ways to optimize a live connection report??

My report is very slow. It buffers a lot.

[v-jianboli-msft · Accepted solution]

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

Optimizing Premium capacities

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.

[lbendlin]

more details please. Is this a shared capacity or Premium?  Have you enabled the service cache?