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...
That looks accurate. How do you know that records are duplicated?
When I load in this dataflow into a report, my numbers for a specific day are inflated. When digging deeper, I can see multiple records for the same ID, which should be impossible as it's unique.
When I consume the dataflow in a new report, it's duplicated when filtering on one of these ID codes. Doing the same in the service though only brings back one result, which is strange...