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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
niklas3000
Helper I
Helper I

Import power bi reports really slow to open first time after refresh of data

Hi!

 

I have a problem with power bi reports that takes a really long time to open first time after refresh (aprox 45 seconds).

After the report has been opened one time by any user it opens fast.

Seems like the model in the report is cached in report server

Is there a way around get around this problem? Have the report server to cache the model itself before the first user opens the report?

 

Regards

Niklas

4 REPLIES 4
Shahfaisal
Solution Sage
Solution Sage

If the problem is ONLY with one specific report and others run fine - Are you using import mode or direct query mode? If it is direct query, and if you are using a query to retrieve data, I would run it against the database and if it works the same way against the database.

If the problem is with all the reports taking too long to run for the first time - Reporting Services goes to "sleep" after being inactive for a long period of time. Take a look for a potential solution - https://pawlowski.cz/2011/07/31/solving-issue-long-starting-report-ssrs-2008/

 

We are using import mode.

All of the reports that have a lot of data are slow to run the first time. But after running one of the reports, the others reports that has not run yet will still be slow. So it is not a state for the whole report server, each report has to be opened one seperatly in order to open fast.

To me it seems like when the report opens, its model is cached in report server, the next time someone opens the report it will open fast.

We need something like a warmup script that opens all the reports, or, preferably, if there is a function in report server that handles this. Can't be only us having this issue. 

From your response, it is not clear if it is on report or all reports. As I mentioned before, reports in report server tend to run slow after a period of inactivity. Did you look at the article I shared?

I did read the link, I can't see that is the solution for our problem. I re-wrote my earlier reply. I saw it was quite confusing 🙂 Hope it is clearer now.

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.