Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
gwhiteman
Frequent Visitor

Paginated Report slow first time it is run (Power BI Report Server -on prem)

I have several paginated reports that are very small and quick to run.
I have loaded them onto our Power BI Report Server (on prem) and noticed that first time take >30 seconds to run.
After that first run, they run return almost immediately. 

 

These are the only two paginated reports and they are NOT in high use. I am assuming the service is starting up for during the first 30 seconds. Is there a way I can 'warm up' the service? 

1 ACCEPTED SOLUTION
d_gosbell
Super User
Super User


@gwhiteman wrote:

I am assuming the service is starting up for during the first 30 seconds. Is there a way I can 'warm up' the service? 


I do not believe this is the source of your issue. I've never witnessed this sort of issue on any of our Report Server environments.

 

I would suggest checking the ExecutionLog3 view in the ReportServer database for these reports. This should give you a breakdown of the query time and the rendering time for each report run. One other possibility is that this could be caused by a delay in authenticating to the source database.

 

But if you don't see any difference in the ExecutionLog3 view then I would suggest checking the Report Server log files as there may be some messages in there that will give you a hint as to what is causing this delay.

View solution in original post

10 REPLIES 10
d_gosbell
Super User
Super User


@gwhiteman wrote:

I am assuming the service is starting up for during the first 30 seconds. Is there a way I can 'warm up' the service? 


I do not believe this is the source of your issue. I've never witnessed this sort of issue on any of our Report Server environments.

 

I would suggest checking the ExecutionLog3 view in the ReportServer database for these reports. This should give you a breakdown of the query time and the rendering time for each report run. One other possibility is that this could be caused by a delay in authenticating to the source database.

 

But if you don't see any difference in the ExecutionLog3 view then I would suggest checking the Report Server log files as there may be some messages in there that will give you a hint as to what is causing this delay.

Anonymous
Not applicable

Hi @gwhiteman ,

could you please let me know how you resolved this issue, i am also facing this issue. Initially it take around 45 - 50 secs in later runs its coming under 25 secs.

Hi @Anonymous,
I don't recall what was done to resolve this problem as I did not install/maintain the servers. I vaguely remember we changed some HA settings and update our Oracle drivers. Sorry I can't be of more help. \]

PowerBI Report Server and SSRS are trying to reach out for some MS metric servers on first report execution. You can monitor this in your browser and disable it by configuration or regedit. In my case this was the cause for slow initial report loading while the firewall didnt allow it and the requests timed out.

Do you recall exactly which configuration setting this was? I have a paginated report that takes a number of seconds to load initially, and I'm trying to resolve that. Is it related to this?

Sorry that was a long time ago, I don't recall what the changed was.  

We also moved from Report Server to Power BI Service.

How are you finding your RDL performance in the service? That's where our issues are, and they seem to do with loading parameters on the initial load of the report.

We find hte performance in the service was great. It was only when running Power BI Report Server on prem we experienced it.

Are you using a gateway to connect to your SQL server? Or are you connecting directly to Azure SQL server instances?

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.

Top Kudoed Authors