Using Table.AddKey does not work. Primary Key is not recognized.

[Anonymous]

I'm creating a dataflow which imports data from an SQL DB with the on-premise data gateway to the dataverse. I want to import the data into an existing table "account". To update the records I need to define a primary key which I do through Transform >Mark as key and set "isPrimary" to true.

This works just fine, but when I want to use this configuration to load the data into an existing table, the key is not recognized.

Where did I make an mistake?

[Anonymous · Accepted solution]

The solution I found is that I need to create a key in the solution itself. Which then I can select in the power query.

But still, I don't know when the Addkey is necessary.

[amitchandak]

@Anonymous , In account table, before the step to add key add delete duplicate based on account column

[Anonymous]

Unfortunately it didn't work. The key column value is still (none) when I use the "Load to existing table"