Forum Discussion
Incremental Refresh with Dataflow is duplicating
I have a dataflow that I'm trying to setup incremental refresh. I have set it up but no the dataflow has some rows that have duplicate of my primary key from the base fact table. I can see the 2 rows...
otravers
Community Champion
Community ChampionMake sure that one of your date filters doesn't have the = sign, i.e. use >RangeStart and <= RangeEnd or >=RangeStart and < RangeEnd. Here's a good entry to guide you:
http://biinsight.com/implementing-incremental-refresh-in-power-bi-part-1/
Yes I made sure about that.. I read that article here is the filter
Table.SelectRows(#"Removed columns", each DateTime.From([UPDATED]) >= RangeStart and DateTime.From([UPDATED]) < RangeEnd)
but this only applies to the desktop not the service... so I'm checking the dataflow using power query to see the duplicated row with the primary key (first column)