Forum Discussion
Slow initial load
HI gustavjMC ,
You could open the Query Analyzer and see what is doing (or not doing). If you don't find anything obvious there, you could do a network trace (like with fiddler) to confirm that everything is communicating as expected.
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 ,
By Query Analyzer, do you mean the performance tool in Power BI that u can use to track the querys? Because I've already done that and analysed my querys in DaxStudio, everything looks ok there.
I can refresh the data very fast in power bi service so I can't really see in what way my querys could be the problem here. It's only that first initial buffer in the service that is slow.
I have exactly the same problem: a report with several pages, everything in direct query mode beside of 2 dimensions that rarely change (date and a static list). Opening the report the first time takes roughly 45 seconds, once it's loaded each click never takes more than 5 seconds to query the corresponding data and update it's visuals.
I also tried Power BI Query Cache to speed up initial page load, but: if someone loads a report the first time and closes the Browser window before the report has been loaded completely, he will see next time he opens up that page a messed up version of that report with lots of error messages. This needs to be fixed than by hitting manually the refresh button, which is a pretty bad user experience from my point of view.
Using Performance Analyzer in Power BI Desktop is also no option, since the report must be already fully loaded to get that feature working.
Edit: I noticed that the same report published on Power BI Reportserver (connected to an On-Prem SQL Server) takes much shorter to load than the same report published on Power BI Service. For sure a Power BI Data Gateway creates more delay that a direct On-Prem SQL connection, but I wouldn't expect such a massive difference.
Appendix: it turns out that the issue exists on both PBI Reportserver and PBI Service. I was misslead by comparing with different parameters.
Did you ever solve the issue? I have the same problem. Slow inital load on the Service (15+ seconds) (not on Desktop), then it works super fast. No DAX, very small dataset - I'm connected to Dataverse, and I'm pulling in 3 tables with <50 rows...
How did you fix this issue at the end?
