Announcements
5
I have created a dataflow with a SQL Connection. Every time I run the dataflow I receive an error that my primary key cannot be created because it is a duplicate. I delete the Primary Key and continue to get the same error. How can I avoid getting this error continually when I have recreated the primary key. I have deleted the flow and connection after recreating the key and still get the error when processing the newly created dataflow and connection.
Hi @lynnem,
That's most likely because the records are not cleared in the destination Dataverse table, so every time the dataflow runs it tries to insert duplicates. In the Dataflow, enable the option "Delete rows that no longer exists".
Hope this helps!
#1
WarrenBelz
791
Most Valuable Professional
#2
MS.Ragavendar
410
#3
mmbr1606
275
Super User 2025 Season 1
Share
Report
All responses (
Answers (
