Forum Discussion
Power BI Report server takes very long for the first time loading
Hi,
I'm publishing my power bi reports (which is live connecting to SSAS) to PBIRS.
For the first time load the report in PBIRS portal, it takes 3-4 minutes which is very slow even when the amount of data in SSAS is not big.
Once reports are loaded, it appears quickly when I hit refresh.
Has anyone overcomes this issue before? Please help.
Thank you.
6 Replies
- Greg_Deckler
Community Champion
Anonymous Well, could be one of two issues. One, PBIRS is not warmed up or if not that then the first time you are hitting the live connection it is pulling from the source whereas after that perhaps it is hitting cache.
- AnonymousNot applicable
Hi Greg_Deckler
I'm using SSAS + Power BI live connection, so it's might not be the cache. As once the visuals are loaded I can interact with them and performance for re-rendering those visuals is good.
So it could be the server is not warmed up. But when I tried with incognito browser to access the same report, it still take very long.
I performed steps below:
- Open a new incognito browser, paste the report URL
- Enter username/password to login
- wait 3 minutes for the report to load
- Close the browser
- Open a new incognito browser and repeat those step again. ==> at this time, It's still slow.
- Greg_Deckler
Community Champion
Anonymous Hmm. Good test. I would say that rules out PBIRS warm-up. Let me do some digging and see what I can find.
- Open a new incognito browser, paste the report URL