Forum Discussion
Failed refresh due to duplicates in data table created by users updating data during the refresh
Hi I have an odd problem that I have noticed and wondered if anyone else has experienced something similar and would know how to fix it A report using data from Azure DevOps fails to refresh ...
v-luwang-msft
Community Support
Community SupportHi annalisekerr ,
In my opinion, try not to manipulate the data when refreshing. Just as in a sql(or oracle), if we are doing an update to a table's data, the table will lock up and the associated query process etc. will be inefficient, so it is better to do nothing else with the table when it is locked up.
Pls refer the below links and check if it is helpful:
Best Regards
Lucien
Thank you, yes my imediate thought was to make sure the refresh is scheduled for during the night to ensure no one is using the data source. The report users are not so keen on that idea 🤔, hence why I wondered if anyone had an alternative solution.