Forum Discussion
Slow initial load
Hello! I've created a PowerBI report that I previously had some performance issues with. I've now corrected all of those performance issues and have < 7 seconds of waiting time on each report pag...
Hi Goofr ,
Are you using a Gateway? There is an update to help with Azure SQL outages which might be affecting you as well. (june 2021 Gateway Update)
Hello,
I'm not using a gateway because my data lives in the cloud (Azure SQL database).
I think it has something to do with cold and hot model. When the model is loaded then initially it's execution time on the database is slow because the queries aren't being stored in cache.
When the model is loaded in memory and the queries are executed everything works fine until the model is offloaded.
The thing is: it doesn't work the way it used to work.
Frank