Forum Discussion
Phil_pac
3 years agoRegular Visitor
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...
- 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.
v-alipat
3 years agoMicrosoft Employee
Hi!
Quick question - is your Report Server machine in the same timezone as client machine? (machine that you access the Report Server Portal from)