Forum Discussion

Phil_pac's avatar
Phil_pac
Regular Visitor
3 years ago
Solved

Report Server Scheduled refresh issues

Working with Power BI report server september 2022. We have a bunch of reports with scheduled refresh. I would like to understand why some of the refresh plans stays stuck on status Refreshing in pro...
refresh issue
scheduled refresh
  • Phil_pac's avatar
    Phil_pac
    3 years ago

    Found out that the table dbo.Event in the Power Bi database had over 60 000 rows. Truncated the table and that fixed the issue.

    One of the main thing is I need to educated Report creaters to not make refresh schedule of 2min - 5 min or even 30 min... this is not best practice and can cause this types of issues.

     

    But for now even with some reports setup like that we have been running fine for a few days now and the event table has not filled up yet. 

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi Phil_pac ,

Please try to click referesh button for report in Power BI Report Server Portal, it works like refresh in Power BI Desktop. When you open the report in the Portal, you could see the button "Refresh", please click it.

Best regards,
Community Support Team_ Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

  • Phil_pac's avatar
    Phil_pac
    Regular Visitor
    3 years ago

    No this is not it. That only refreshes the page. The purpose of the scheduled refresh is that the data will refresh from what ever the source is.