topic Report Server does not complete Data Refresh in Report Server

Report Server does not complete Data Refresh

Anonymous — Tue, 09 Jul 2024 19:08:58 GMT

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.

Re: Report Server does not complete Data Refresh

Anonymous — Wed, 10 Jul 2024 05:39:24 GMT

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.

Re: Report Server does not complete Data Refresh

Anonymous — Wed, 10 Jul 2024 17:38:17 GMT

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