[Help] Power BI Report Slow on Initial Load (Live Connection)

Hi Zhinee 
That “first-load slowness” is pretty common with Power BI reports using live connections, usually, it’s caused by the data source or Power BI service “warming up” caches or query plans after inactivity.

Here are few workarounds:

• Schedule periodic “keep-alive” queries to prevent cache timeouts.
• Optimize your data model and queries for faster execution.
• If possible, use Import mode for critical reports needing instant load.

Did it work? 👍 A kudos would be appreciated
🟨 Mark it as a solution to help spread knowledge 💡

🟩 Follow me on LinkedIn

One of the ways would be use Power Automate to trigger a dataset refresh or run a query against a semantic model using Power BI REST API every 30 minutes.

However, Microsoft does not provide official documentation specifically endorsing the practice of keep-alive queries in shared non-Premium capacity workspaces. The concept of manually initializing datasets is more of a community best-practice workaround, rather than an officially documented feature.