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 Dyana,
My solution for this case was make a buffer for the sorted set by the modified date (descending), and then remove the duplicates.
...
#"Linhas classificadas" = Table.Buffer ( Table.Sort(#"Colunas removidas", {{"Id", Order.Ascending}, {"Modificado", Order.Descending}})),
#"Duplicatas removidas" = Table.Distinct(#"Linhas classificadas", {"Id"}) ...
Obs.: without applying the buffer, power bi does not guarantee that the first row of sorting will be kept.