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 within the desktop, I'm receiving duplicate rows but the 'modified' and 'created' dates are different. One shows 30/01/2022 the other is 01/02/2022.
My incremental refresh is configured to store data for the last two years, and refresh rows for the last three months based on 'created' date, and automatically detect changes is enabled and set to watch 'modified' date.
I know if I do a manual refresh, it'll likely fix the issue as it'll do a normal load from the report, but I don't want to do this, I'd rather incremental worked as I would hope.
When I query the row within the service, only the one row is returned - I add this step after the 'canary load' step at the end of all the steps on the workspace.
Can anyone assist, or is this expected behaviour?
Many thanks,
Dayna
