Forum Discussion
Incremental refresh causing duplicate rows
Hello, I've implemented incremental refreshes on one of our fact tables, called 'Transactions'. I can see on a given day there's been a change to some rows, and when this dataflow is consumed...
Hi I have a similar issue
we have last updated date field across which we are enabling incremental refresh
I followed as per MS documentation
currently we enabled refresh for last 15 days.
so what's happening is it is updating and refreshing the data for these 15 days window.
now problem here is if I have a record which last updated 4 months back and is updated today again, it is not removing the 4 months back row and is getting added resulting in duplicates
how can we adress this issue ??