Report Server does not complete Data Refresh

[Anonymous]

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.

[Anonymous · Accepted solution]

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 Event

Below 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.

[Anonymous]

Thanks a lot Xianda! It solved the problem, you rocks!!