Dataflow Primary Key

Like (0) Share

Report

Posted on 16 Apr 2021 07:16:22 by lynnem

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.

Categories:

Environment

Management

I have the same question (0)

All responses (1)

Answers (0)

EricRegnier 8,714 Most Valuable Professional on 16 Apr 2021 at 09:05:54

Like (0)

Report

Re: Dataflow Primary Key

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!

Was this reply helpful? Yes No