Forum Discussion
Setup Incremental refresh on Many to Many relationship table
amitchandak But the below statement from Microsoft docs contradicts with incremental refresh works for many to many , because it expects to have unique values in 1 side of the table , which mean many to many will always fails the above condition.
Hi Anonymous
1.Check that when you set the rangestart and rangend paramaters the date should be [date]>=rangestart and [date]<rangend (cannot equal to rangend).
https://learn.microsoft.com/en-us/power-bi/connect-data/incremental-refresh-configure#filter-data
2.The error message in your incremental refresh, it means that, because of the post date change, the unique id appears in another partition so that it return the duplicate values errors, you can refer to the following link about the error.
So it needs to use SSMS to refresh all partitions from the point where the change is located up to the current refresh partition.
And you can also refer to the similar case.
Incremental Refresh - Duplicates or Missing Update... - Microsoft Fabric Community
Solved: Incremental Refresh - Duplicate Rows for Refresh W... - Microsoft Fabric Community
Solved: Re: Incremental refresh failing due duplicate reco... - Microsoft Fabric Community
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.