topic Power BI Report server takes very long for the first time loading in Report Server

Power BI Report server takes very long for the first time loading

Anonymous — Wed, 07 Aug 2024 14:32:42 GMT

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.

Re: Power BI Report server takes very long for the first time loading

Greg_Deckler — Wed, 07 Aug 2024 14:41:06 GMT

@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.

Warming up SSRS? – SQLServerCentral Forums

Re: Power BI Report server takes very long for the first time loading

Anonymous — Wed, 07 Aug 2024 14:56:08 GMT

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.

Re: Power BI Report server takes very long for the first time loading

Greg_Deckler — Wed, 07 Aug 2024 14:59:20 GMT

@Anonymous Hmm. Good test. I would say that rules out PBIRS warm-up. Let me do some digging and see what I can find.

Re: Power BI Report server takes very long for the first time loading

Greg_Deckler — Wed, 07 Aug 2024 15:04:52 GMT

@Anonymous Here are some possible solutions:
Troubleshooting - Solved: Slow On-Premise Report Server Performance /powerbi... - Microsoft Fabric Community

Custom visuals - Slow Custom Visuals In Power BI Report Server | Power BI (devoworx.net)

Re: Power BI Report server takes very long for the first time loading

Anonymous — Mon, 12 Aug 2024 14:20:33 GMT

Hi @Greg_Deckler

The thing is, no report is opened at that time, I just go to <host>/reports; this should be the home page with list of reports and folders only.

Then I did a check by hitting F12 and found that it took more than 2 minutes (over 3 minutes in total) to load 2 js files for the first load.

I'm not sure those js files are statics and could be cached or it's something else from PBIRS.

(I'm not having good knowledges about web stuff)

Re: Power BI Report server takes very long for the first time loading

hackcrr — Mon, 12 Aug 2024 23:12:05 GMT

Hi, @Anonymous

Large JavaScript (JS) files or other non-cached resources may cause slow initial load times.
Solution:
Ensure that static resources such as JS files have appropriate cache headers. Use a Content Delivery Network (CDN) or optimize network paths if PBIRS is hosted remotely.

If the service account used by PBIRS does not have the appropriate permissions or is configured incorrectly, it can cause delays.
Solution:
Ensure that the service account has the necessary permissions on both the PBIRS and SSAS servers. Verify the impersonation mode in SSAS, as incorrect settings can cause performance issues.

Start SQL Server Profiler and connect to your SSAS instance.
Start a new trace, load a report, and see which queries are running and how long they take.
Use Task Manager or Performance Monitor on the PBIRS and SSAS servers to monitor CPU, memory, and disk I/O.
Check for high usage spikes during the initial report load.
Review the PBIRS log: The PBIRS log can typically be found at C:\Program Files\Microsoft Power BI Report Server\PBIRS\LogFiles. Check the log for any performance-related errors or warnings.
Create a simplified version of the report with fewer visuals to see if it loads faster.
Identify complex visuals: Gradually add visuals to determine if a specific visual is causing the delay.

hackcrr

If I have answered your question, please mark my reply as solution and kudos to this post, thank you!