Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
We have two different reports on the web service, one named "[RTM] Desktop" and another named "[Outgoing RTM] Desktop". Essentially, since a couple of weeks ago, the data of "[RTM] Desktop" was supposed to move over to "[Outgoing RTM] Desktop" automatically (changes made in the SQL Server view), and "[RTM] Desktop" was supposed to get new data.
However, the first report, "[RTM] Desktop", keeps getting overridden by data that's supposed to now be in "[Outgoing RTM] Desktop", whenever a scheduled refresh happens, almost like it's being reverted back to its old state (except the data is up to date so it's not that the data was cached from a couple iterations before). The "[Outgoing RTM] Desktop" report has the correct data, so we have two reports with the same dataset.
We've tried the following things to try to figure out what's going on:
We really don't know why our "[RTM] Desktop" data keeps getting overridden everytime there is a scheduled refresh (once per day). It's quite cumbersome to have to refresh the data locally on PowerBI Desktop and reupload every single day, just to have the right set of data on the web dashboards.
Any thoughts?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.