cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
james_hathaway
Advocate III
Advocate III

Dataverse Dataflow lookup field not accepting alternate key

When creating a dataflow to sync data from a SQL databse into Dataverse, the Lookupfield of the destination table are not accepting the correctly configured alternate key.

 

The dataflow fails with an error message:

"0x8006088a: The key in the request URI is not valid for resource 'Microsoft.Dynamics.CRM.sdx_itemparents'."

 

The data sent to dataverse by the dataflow is: "sdx_Item@odata.bind": "/sdx_items(sdx_productcode='XX7281.60')" and the "sdx_item" table has an alternate key set to the "sdx_productcode" field:

james_hathaway_0-1650965204590.png

Dataflow column mapping: (There happens to be 2 lookup fields to the same "Item" entity, as this table is setting up a "parent" relationship form Item -> Parent Item)

james_hathaway_1-1650965271970.png

So it should perform the lookup to the record correctly, but is not working.

I have also checked that the Key is active (using Classic mode):

james_hathaway_2-1650965420048.png

I have searched all Microsoft Documentation and the forums, and cannot find any reference to this error anywhere.

Has anyone else seen this error?

Any ideas why this lookup is not working?

 

 

2 REPLIES 2
PHalseyKMS
Regular Visitor

I have noticed a similar error occur in one of my dataflows, but it's inconsistent, sometimes the error occurs on one table mapping and on the next run that record works but the error occurs on a different table.

Also only some records fail for a table and they all have the same key construct.  

chico
Advocate V
Advocate V

seeing this failure as well, but very inconsistent.

The refresh runs every 2 hours and maybe once a day, it fails with this error,,,

Helpful resources

Announcements
Power Platform Call June 2022 768x460.png

Power Platform Community Call

Join us for the next call on August 17, 2022 at 8am PDT.

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Users online (1,858)