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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

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
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

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

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

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

Top Kudoed Authors