cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Frequent Visitor

Dataflow import to CDS error "missing destination field" on alternate key

Hi,

 

I'm importing data from an on-premise SQL Server database into CDS via the on-premise gateway. I have already set up my CDS entities with alternate keys to allow relationships (lookups) to be maintained between the source and CDS when synchronizing. I seem to have a bug in my dataflow where it is trying to import to a destination field (alternate key on a related entity) that doesn't exist in the related entity. The error message in my dataflow refresh history detail is: "Missing destination field cr423_gradergrower.cr423_grader in the schema".

 

The destination field is automatically set to "cr423_GraderGrower.cr423_Grader" but I think it should be "cr423_GraderGrower.cr423_Grader.cr423_SerialNumber" because the "cr423_Grader" related entity has a key "cr423_SerialNumber". Is Dataflow able to use cascading (multi-level) alternate keys in this way, or should I try another way to ensure relational integrity?

 

Capture_PowerAppsDataflow_FieldMapping.PNG

 

 

Capture_PowerAppsDataflow_BatchEntity_Fields.PNG

 

 

Capture_PowerAppsDataflow_GrowerEntity_Keys.PNG

 

 

Capture_PowerAppsDataflow_GraderEntity_Keys.PNG

 

 

 

3 REPLIES 3
Super User II
Super User II

Hi @packnology,

Dataflows doesn't support multi-level alt keys and I don't even think it supports alt keys defined with >1 fields. Any chance you can modify your entity model to have a direct link to Grader? Another option is to have a new "staging" entity and use that as your destination entity, then with the help of Power Automate (or another preferred method), create the "real" entities. You can also leverage Power Automate as an alternative to Dataflows if Dataflows doesn't satisfy your requirements.

Cheers
 

New Member

Hello, Ran into the same problem here with the following error:

 

Missing destination field cr915_category.cr915_name in the schema

 

 The solution for us was as follows:

  1. Click the Settings Cog -> Admin Center (Power Platform admin center)
  2. Click Data Integration on the left menu
  3. Click the Connection sets tab
  4. You will find a connection set in here related to the Dataflow, named similar to (in my case): D2E-20201015-223826
  5. Click the connection set found in step 4
  6. Select the Integration key tab
  7. Hopefully, despite adding an alternative key before you got this error, you will find there are no Integration keys assigned to the parent tables. 
  8. Click Add key against the parent table and select the same field you have set as the alternative key (what you want to lookup against)
 

I have not seen this documented or answered anywhere online. Hope it helps

Integration Key.PNG

Greetings all.  I was running into exactly this problem as well with a CDS custom table (Case) related to a CDS delivered table (Contacts) and HarryJohn's solution resolved it for me (thank you!).  Now, however, when trying to import Note/Annotations associated with the Case, I get a similar error:  

 

Missing destination field objectid.crf8b_legacycase in the schema

Below are screen shots of my data flow field mapping and the Connection Set Import Key pages respectively.

 

Any ideas?  Thanks much!

Power Apps Import Problem DataFlow.jpgimage.png

Helpful resources

Announcements
News & Announcements

Community Blog

Stay up tp date on the latest blogs and activities in the community News & Announcements.

Power Apps Community Call

Power Apps Community Call- January

Mark your calendars and join us for the next Power Apps Community Call on January 20th, 8a PST

PP Bootcamp Carousel

Global Power Platform Bootcamp

Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.

secondImage

Power Platform Community Conference On Demand

Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!

Users online (10,205)