Forum Discussion

martinbrauer86's avatar
martinbrauer86
Frequent Visitor
1 year ago
Solved

Report server On Premise refresh failed

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 ...
"Refresh"
"Schedule Refresh"
OnPremise
  • martinbrauer86's avatar
    martinbrauer86
    1 year ago

    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.

martinbrauer86's avatar
martinbrauer86
Frequent Visitor
1 year ago

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's avatar
Anonymous
Not applicable
1 year ago

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