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

Problem Importing Case (incident) data to From one Dataverse environment to another using Dataflows

Hello,

 

I'm trying to import Case data from one Dynamics 365 environment to another using Dataflows, but now it is saying that the CustomerId is required, but I cannot map the CustomerID in the mapping stage. I have already created Alternate Keys in the target environment.

 

There is a note in the documentation stating that polymorphic relationships are not yet supported, could that be the issue? That means I cannot import cases using Dataflows, since the Customer field is required? Any alternative in Dataflows, or just SSIS?

 

Thank you!

1 ACCEPTED SOLUTION

Accepted Solutions
Mira_Ghaly
Dual Super User II
Dual Super User II

@fnunes

As you have mentioned polymorphic lookups are not yet supported in data flows so the alternative will be SSIS package and you can easily do this using king waysoft and you will not need a license if this is a once off task and you can execute packages directly from visual studio.

 

If this post helps you with your problem, please mark your as Accepted solution.If you like my response, please give it a Thumbs Up.

Blog: here

View solution in original post

2 REPLIES 2
Mira_Ghaly
Dual Super User II
Dual Super User II

@fnunes

As you have mentioned polymorphic lookups are not yet supported in data flows so the alternative will be SSIS package and you can easily do this using king waysoft and you will not need a license if this is a once off task and you can execute packages directly from visual studio.

 

If this post helps you with your problem, please mark your as Accepted solution.If you like my response, please give it a Thumbs Up.

Blog: here

Hello @Mira_Ghaly,

 

Thank you for your answer and confirming my hypothesis and providing an alternative.

 

I wish you a great week!

 

Fabrício

Helpful resources

Announcements
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.

PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

PA.JPG

New Release Planning Portal (Preview)

Check out our new release planning portal, an interactive way to plan and prepare for upcoming features in Power Platform.

Users online (3,480)