Dataflow Refresh Error regarding alternate key

Question

I have many Dataverse dataflows that I run for various applications. Each day, these dataflows run and process 10s of thousands of records successfully, but also each day, I get 1 or 2 errors that says...

{"error":{"code":"0x8006088a","message":"The key in the request URI is not valid for resource 'Microsoft.Dynamics.CRM.intelhub_earnedmedia_combined'. Ensure that the names and number of key properties match the declared or alternate key properties for the resource 'Microsoft.Dynamics.CRM.intelhub_earnedmedia_combined'."}}

What's interesting, if I refresh the dataflow again, it usually comes back with no errors. But it is annoying that I get the error above in the first place.

Does anyone have any ideas why this error happens in the first place and if there are any solutions on how to resolve it for good?

I just wanted to confirm that each Dataverse table the dataflow is feeding does have a PrimaryKey set.

silcambro · Answer

Hello,&nbsp;we opened a ticket and just got a feedback from Microsoft:&nbsp;We shared the details to the PG team and got an update from them that the fix for the transient 0x80060888 failures is expected to roll out to all PROD regions&nbsp;by 08/26.&nbsp;Let's pray 😉&nbsp;--silvano&nbsp;

silcambro · Answer

&nbsp;Hello All,&nbsp;this has been fixed my Microsoft. there was a new release on August 26th 2023, that fixed our issue.&nbsp;&nbsp;Hope this helps&nbsp;--silvano

otravers · Answer

Looks like Dataverse being flaky, you're not the only one running into this:

https://powerusers.microsoft.com/t5/Microsoft-Dataverse/Dataverse-Dataflow-lookup-field-not-accepting-alternate-key/td-p/1559012

pbi_queryous · Answer

I get this every day. At random, for random individual records. The Dataverse is an unintuitive wilderness of illogical constraints and bugginess with little or no documentation to explain these errors. The error message is also a lie, it explains nothing.

silcambro · Answer

Hello,&nbsp;having the same issue, only when we schedule the Dataflow, if we run it manually there are no issues.&nbsp;Did you find any solution on this?&nbsp; Did you open a ticket ?&nbsp;Thanks&nbsp;--silvano

Forum Discussion

Dataflow Refresh Error regarding alternate key

7 Replies

Related content

Fabrics to Dataverse - Dataflow Alternative

Alternative to SWITCH ()?

New and Need Help - Alternating Rows

Regarding Data Load issue

Dataflow Gen2 incremental refresh alternative to modified date