Forum Discussion
Slow initial load
Thank you for the tips and tricks!
Unfortunately none of them works for me. The problem with my report isn't that it's generally slow because generally, it's quite fast. The problem for me only exists when I open the report for the first time of the day in Power BI service. It's fast in Power BI Desktop and fast in Power BI service when it's not the first time I visit it for the day (or atleast for at couple of hours).
It's really hard to troubleshoot this problem because it does as I said only occur when visiting the report for the first time in a while or directly after i published a new version of the report from Power BI Desktop.
Is there any visuals or something that is only downloaded when visiting the report for the first time in a while or where is this problem coming from?
HI gustavjMC ,
Yes, when you first open the report, it loads into memory and runs on your machine to get the data ready to use. This is standard. If it is slow during this part that means that you have either an incredibly massive dataset or you have inefficient queries or you have lots and lots of Power Query edits that it runs through, or you have a very slow and underpowered machine, or you have a slow network or any of the other things that myself or Anonymous suggested.
Once it is loaded, it will run fine and quickly.
If it really takes a couple hours to get ready to use then you need to re-evaluate all of these options to get this to be a more effective report. Or, you can just live with the fact that this is how long it takes.
I would appreciate Kudos if my response was helpful. I would also appreciate it if you would Mark this As a Solution if it solved the problem. Thanks!
Hi collinq
Thank you for your answer!
Just to be clear, it doesn't take a couple of hours for the report to get ready to use. When i say slow, I mean like 20 seconds.
EXAMPLE:
- I visit the report at 07:00 in the morning, the report takes about 20 seconds to load and then I can browse the report's all pages without significant loading time.
- I visit the report an hour later, 08:00 in the morning. The report is now fast even though it is updated with new values since last time i visited the report.
- I visit the report two hours later at 10:00 and the report is still loading very fast.
- I wait 7 hours and opens the report at 17:00, the behaviour of the report is now like it was in the morning. It's taking about 20 seconds to do an initial load and then I can browse and update the values very fast.
I hope this example makes it more clear what my problem really is 🙂
HI,
I am also facing the same issue, no huge data no complex queries. but the initial load tacks 10 to 15 minutes. there is any resolution. kindly help.
