topic Re: Power Platform Dataflow Upsert Error in Data Engineering

Power Platform Dataflow Upsert Error

scottexe24 — Wed, 18 Dec 2024 15:50:19 GMT

Can someone help me understand possible reasons for this error? I have a key on my table based on 13 columns that I'm trying to Merge into. I was able to initially append records (without the key field). Subsequently I created the key with no problem indicating that the combination of the 13 fields on each record is unique. Then I tried to change the dataflow to a merge and upsert the same exact data and I get this error.

Re: Power Platform Dataflow Upsert Error

scottexe24 — Wed, 18 Dec 2024 18:29:10 GMT

For anyone else running into this issue, I concatenated the 13 fields in my source query and created a new column in my target Dataverse table called "Merge_Key". Then instead of creating the key on 13 columns I created it on this 1 new column and the merge operation worked. I don't understand why, but seems to be working now.

Re: Power Platform Dataflow Upsert Error

Anonymous — Thu, 19 Dec 2024 03:03:07 GMT

Hi @scottexe24

Check the following article, it might be helpful.

Field mapping considerations for standard dataflows - Power Query | Microsoft Learn

According to my understanding on the article, using a combination of fields as an Alternate Key for Upsert operation was supposed to work.

Best Regards,
Jing