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. 

Phil_pac's avatar
Phil_pac
Regular Visitor
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.