Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

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. B...
PBI
ReportServer
scheduler
  • Anonymous's avatar
    Anonymous
    2 years ago

    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's avatar
Anonymous
Not applicable
2 years ago

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's avatar
    Anonymous
    Not applicable
    2 years ago

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