Forum Discussion
PBI Server May 2020 not refreshing saved reports
Anonymous wrote:
So, the only workaround is to return to Jan 2020 version?
Is it safety just to install the older version?So one workaround is open your report in desktop, then go back to the portal and delete the file from there before you save. But that is not great for end users.
Otherwise you either have to wait for a fix or look at going back to Jan 2020. Although Ideally you should restore the ReportServer database from a backup as I'm not sure if the May release made any schema changes or not.
Realistically my guess is that it could be at least a week or two, maybe longer before an update is published. Even if they have a fix for this today Microsoft will need to do a full test run to make sure that the fix does not break anything else. The last thing they want to do is rush out a fix that breaks something else.
Memorable Memberadditional workaround how reduce impact of this issue is decrease ModelCleanupCycleMinutes and ModelExpirationMinutes parameters in SSMS of RS. Which reduce time to retried model from cache, and load fresh model from DB. But it works only for reports which are not used constantly (expiration time is counting only when reports is not in use)
Memorable MemberAdditional info: (probably, in my case) if PBIRS is running only on one server, this issue affecting only manual dat refresh from PBID.
If PBIRS is runnning on multiple servers and data refreshes are running on different sever than front end PBIRS (directed by IsDataModelRefreshService settings in rsreportserver.config) this issue affecting both, manual data refresh from PBID and also scheduled data refresh on PBIRS server.