Forum Discussion
How to properly implement incremental refresh with a last_update column.
Hi Anonymous,
You may consider ticking the option Detect data changes and the best strategy would be Filter date with RangeStart and RangeEnd, then detect data changes based on last_update.
You could refer to the official doc to learn more about the option Detect data changes.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let me know. Thanks a lot!
Best Regards,
Community Support Team _ Caiyun
Hey, v-cazheng-msft thanks for your reply.
I've one more question, please.
If
- the incremental refresh setup is 7 days before the refresh date
- someone edited the history data (let's say the date of the modified data is 1 month before the refresh).
- the last_update of this data will turn to today
Is my incremental refresh will update this value? I'm not sure according to the schema at the bottom of your screenshot and the explanations about the data changes.
Thanks,