Power Query doesn't update existing Rows

(0) Share

Report

Posted on by Der_Jean_Marc1

Greetings Power Query community,

I have some issues with two Dataflows matching the same reqNR and updating the row in a Dataverse Table.
What I want to accomplish is:
Dataflow 1 creates some data.

Dataflow 2 matches the reqNR and updates the Rows with additional info.

Now Dataflow 2 is creating a new Row even if the reqNR is the same.

I don't get why the Flows behave like this, I think I'm the Problem here and I'm doing something wrong.

Can somebody please help me to resolve this?

Thanks in advance
Edit:
If I try to create a new Key for the Table, I get this Error Code after running the Dataflow again:
The CREATE UNIQUE INDEX statement terminated because a duplicate key was found for the object name''and''.