Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
oaledo
New Member

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.

oaledo_0-1720551558795.png

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:

oaledo_2-1720552046791.png

If need some additional information please just let me know.

Thanks.

Oscar.

 

1 ACCEPTED SOLUTION
v-xiandat-msft
Community Support
Community Support

Hi @oaledo ,

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.

View solution in original post

2 REPLIES 2
v-xiandat-msft
Community Support
Community Support

Hi @oaledo ,

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.

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

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.