Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics 365 | Integration, Dataverse... / Using Dataverse with O...
Microsoft Dynamics 365 | Integration, Dataverse...
Suggested answer

Using Dataverse with OData Connection to copy Accounts with Parent Accounts

(0) ShareShare
ReportReport
Posted on by Jerimiah 15

I am trying to migrate data from one Dynamics 365 instance into another, that has the same tables.

We have Accounts, and an Account may or may not have a Parent Account association. I've gone through and tried to use dataflows with an OData connection. This loads a table with the ParentAccountID column that has a link to a record. I then proceed to the mappings, but I don't see any way to map a field to the ParentAccountID column. I've created an alternate key in both CRM environments for the Account record, using the same columns to generate this key. I am able to see the destination field for this new key that I created, but I still don't have a way to hook that to the source field ParentAccountID.

Does anyone have any idea how I can map over these Accounts and make sure they have the proper Parent Account association?

Thanks

  • Suggested answer
    Jerimiah Profile Picture
    Jerimiah 15 on at
    RE: Using Dataverse with OData Connection to copy Accounts with Parent Accounts

    I was able to figure this out by expanding the ParentAccountID column in Power Query. This allowed me to map the alternate key values to the fields under the ParentAccountID Record.

  • Jerimiah Profile Picture
    Jerimiah 15 on at
    RE: Using Dataverse with OData Connection to copy Accounts with Parent Accounts

    Unfortunately I can't do any filtering using the parentaccountid column because it links to a record.

    pastedimage1636662427809v1.png

    I can't seem to get the Dataflow to recognize that as a field I want to populate with a lookup.

  • Suggested answer
    Ragnar Hilmarsson Profile Picture
    Ragnar Hilmarsson 3,427 on at
    RE: Using Dataverse with OData Connection to copy Accounts with Parent Accounts

    Hi

    If i understand you issue:

    I think you need to do it in two steps, first copy account with parentaccountid = null

    then copy account with parentaccountid.  

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey Pt 2

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,861 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,540 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Get batch job history log from D365 FO to Power Automate

Product updates

Dynamics 365 release plans