Hello,
Sometime when we save a new version of a report on Report Server the next refresh seems to bring back the previous version, for example fixed errors will come back or changed calculation will revert.
We've been having this problem on and off since we updated to January 2020 (both Report Server and Desktop are updated), it doesn't happen systematically but it happened at least 3-4 times and I don't remember it happening before.
Here are all the steps that I've done when it last happened.
1) I received a call from user telling me that one of the visual is broken
2) I opened the report in Desktop from the report server (not local pbix)
3) There was indeed a bug in a measure, I made a quick fix
4) I did a full refresh in desktop, everything is fine
5) I saved to the report server, overwriting the previous report
6) Quickly checked the report, everything is fine
7) A few hours later I received another call, the visual is still broken (quick check, it's indeed broken)
😎 I opened the report in Desktop again
9) The report is still fine in Desktop, I did a full refresh in Desktop and everything is still working correctly.
10) Saved the report again on Report server (overwrite), I opened it, everything looks good
11) I manually started a refresh (waiting for it to finish), report is broken again.
12) This time I did a "save as" on Report Server with a different name
13) Configured the Data sources and Refresh (exactly the same as the original), manually ran the refresh (waiting for it to finish)
14) The copy works perfectly while the one that was overwritten is still bugged.
15) Repeated steps 8 to 10 but this time somehow it still works after the refresh.
16) Waited for the next scheduled refresh, everything is still fine. The issue fixed itself.
It worked in the end but I needed to save the "working" report 3 times before it did. Other times I fixed the issue by restarting the Report Server service which is hardly ideal. I'm not excluding user error as the cause but I can't figure out what I'm doing wrong especially since I did the same thing multiple times with various result and this is not the first time it happens.
Anyone else encountered a similar issue? Any ideas?
