Forum Discussion
Report Server does not complete Data Refresh
Hi all,
I have the following issue several days ago.
When I publish a new report or re-configure the Screduled Refresh for old reports, the Status of Scheduler stucks in "Updating" Status.
But the old reports that run and were scheduled 1 month before (without touching them) are working properly (they finish the scheduler correctly).
Here some information of my environment:
If need some additional information please just let me know.
Thanks.
Oscar.
Hi Anonymous ,
For Power BI Reporting Server, in some cases, events are piling up in the ReportServer database event table, causing new plans to fail. You can try deleting these events to allow a new plan to start:
Connect to the ReportServer database.
Execute the following SQL query:USE ReportServer SELECT COUNT(*) FROM Event DELETE FROM EventBelow is the link will help you:
Solved: New scheduled refresh stuck at refreshing - Microsoft Fabric Community
Best Regards,
Xianda Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
Hi Anonymous ,
For Power BI Reporting Server, in some cases, events are piling up in the ReportServer database event table, causing new plans to fail. You can try deleting these events to allow a new plan to start:
Connect to the ReportServer database.
Execute the following SQL query:USE ReportServer SELECT COUNT(*) FROM Event DELETE FROM EventBelow is the link will help you:
Solved: New scheduled refresh stuck at refreshing - Microsoft Fabric Community
Best Regards,
Xianda Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.