Power Platform Community Forum Thread Details

Hi,

I encountered an issue when migrating data from SQL Server to CDS. Data got duplicated when inserting into CDS table, however, there is no duplicates in the source. I tried to export data to csv file for test and got the same issue.

Can anyone help on this? Thanks

Record value from SQL Server are the same but IteminternalId are different. I don't know where is IteminternalId came from.

here is my test flow:

Categories:

General topics

Community site session details

Got Duplicate Data When Syncing Data from a SQL View to CDS Table

Helpful resources

News and Announcements

Quick Links

Introducing the 2026 Season 1 community Super Users

Kudos to our 2025 Community Spotlight Honorees

Congratulations to the February Top 10 Community Leaders!

Leaderboard > Power Automate

Featured topics

Product updates