Forum Discussion
Refresh issue
Hi Prachi_Ramteke It might be because of discrepancies in handling duplicates between Power BI Desktop and the Service. Ensure your duplicate removal logic accounts for all data variations in incremental refresh settings. Check the data source updates for new records violating uniqueness constraints. Adjust incremental refresh policies to include duplicate checks or reprocess full data as a one-time fix. Validate steps using a staging table or intermediate query to ensure consistency.
Hi Prachi_Ramteke ,
Thanks for reaching out to the Microsoft fabric community forum.
Please go through the below document and solved issue which may help you in resolving the issue:
https://learn.microsoft.com/en-us/power-bi/connect-data/incremental-refresh-troubleshootSolved: Re: Incremental refresh is duplicating the records - Microsoft Fabric Community
If this post was helpful, please give us Kudos and consider marking Accept as solution to assist other members in finding it more easily.
Best Regards,
Menaka.
Community Support Team.
Hi Prachi_Ramteke It might be because of discrepancies in handling duplicates between Power BI Desktop and the Service. Ensure your duplicate removal logic accounts for all data variations in incremental refresh settings. Check the data source updates for new records violating uniqueness constraints. Adjust incremental refresh policies to include duplicate checks or reprocess full data as a one-time fix. Validate steps using a staging table or intermediate query to ensure consistency.