cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
lynnem
New Member

Dataflow Primary Key

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. 

 

1 REPLY 1
EricRegnier
Super User
Super User

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".

EricRegnier_0-1607146815688.png Hope this helps!

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Users online (2,328)