Forum Discussion
Mohan128256
Helper IV
Helper IVIncremental Refresh Data duplication, data mismatch
Hello All, I have a table which has around 1.2B of records. I have setup incremtnal load. as 3 yrs archive and 1 day as incremental refresh. but the problem is, though the increment...
Hi Mohan128256
Thanks for the reply from parry2k , please allow me to make some additions.
If both the RangeStart and RangeEnd parameters in a query have equal signs, some rows may meet the conditions of both partitions, resulting in duplicate data in the model.
https://learn.microsoft.com/en-us/power-bi/connect-data/incremental-refresh-configure#filter-data
If our replies is helpful to you, please consider marking our replies as solution. This will help more users who are facing the same or similar difficulties. Thank you!
Best Regards,
Yulia Xu