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...
I've not configured this other than in the UI within the PowerBI service, it has automatically created this:
Table.SelectRows(#"Changed column type 2", each DateTime.From([pro2created]) >= RangeStart and DateTime.From([pro2created]) < RangeEnd)
That looks accurate. How do you know that records are duplicated?