Forum Discussion
Power BI Incremental refresh duplicate issues
Super UserHi. Do you have the "Detect data changes activated"? be sure that if you use that option, it is usually recommended to use a modified date or some way to identify the changed row from the new row with the change. This is incremental refresh, so it's inserting, it will not replace a row in the old history. If you data changes, think about a way of tracking the most recent row (if you want to keep the data changes). If you don't won't that option you probably need to refresh until last period that might be modified.
I hope that helps,
I have a similar scenario
I have only last updated date in my data
so o enable query parameters on that field
so it runs fine for some refreshes
all of a sudden, it starts duplicating the values showing multiple rows and totals gets inflated
so as per documentation, we cannot use same column for both detect data changes and partitions
how can I resolve this ??