Report server On Premise refresh failed

[martinbrauer86]

Dear all

i have a strange problem with our PBI On-Prem 2024.sept version server. A lot of reports are not refreshing sheduled, nor manual. It says "Completed Data Refresh", last run: a date from yesterday. If i add a new schedule, it keeps saying "Refreshing".

in PBI server Logs i cannot see any serious or refresh related error. On MSSQL server Agent, all scheduled jobs did run with OK result.

I installed the PBI server on another machine, copied the ReportServerDB and TempDB and the problem is still the same on the new server.  What sould i check? Thank you for your help!

[Anonymous]

Hi, @martinbrauer86 

First, you should check whether your report data credentials have permission to be placed as your data source.
Make sure you don't schedule too many scheduled refreshes at the same time, which will cause resource congestion with report server refresh request operations.
You can do a simple test by following the steps below:
Upload a report that uses only SQL Server as the data source, the report contains a simple dataset, set up a scheduled refresh for it, then add data to the table in the SQL Server data source, and finally manually perform a scheduled refresh to see if the data is updated (note that you need to press F5 or manually refresh the browser page to see if the changes change).

Now insert a new data and perform a refresh manually:

Return to the report page to see if the latest insert data is displayed:

If your report server refreshes properly in the test above, your configuration is fine. All you need to do is republish your report to Power BI Report Server, restart your report server, and configure scheduled refresh again to make sure that you currently have only one scheduled refresh running to avoid the impact of insufficient resources.

Best Regards

Jianpeng Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[martinbrauer86 · Accepted solution]

Thank you for your answer, after 7 hours of search i found the solution on this forum. The Events table in the reportserver DB had too many records, i had to clear it and all reports started to refresh. It was strange, that many report did refresh, but half of them not, the server CPU and RAM usage was low, and no log entry pointed to refresh problems. I think MS should patch this asap in some form. Thank you again for your help.

[Anonymous]

Hi, @martinbrauer86 

Thank you so much for sharing the solution. Has another part of your report now been refreshed successfully?

If yes, you can mark your response as a solution to be able to help others in the community.
If you still have any questions or need more support, please feel free to let us know. We are more than happy to continue to help you.
Thank you for your patience and look forward to hearing from you.

Best Regards

Jianpeng Li