Forum Discussion
Incremental refresh is duplicating the records
Hi shamnadkalathil ,
According to your description, your incremental refresh data was duplicated after the refresh was performed. This may be due to the duplication of the parameter range you set, e.g. if the start time is set to greater than or equal to, then the end time should be set to less than. If the entire interval is in a closed interval, it will cause the first and last two times to overlap, thus refreshing the duplicate.
Also, do not change the refresh period and time column after the initial incremental refresh is set.
You can change this by referring to the description in the documentation in the following postSolved: Incremental refresh doubles my data - Microsoft Fabric Community
Configure incremental refresh and real-time data for Power BI semantic models - Power BI | Microsoft Learn
Solved: Incremental Refresh - Duplicate Rows for Refresh W... - Microsoft Fabric CommunityBest regards,
Albert HeIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi Idrissshatila , thank you for the reply.
I have unchecked the option "autodetect new relationships after data is loaded".
Is this maybe the issue?