Skip to main content

Notifications

Microsoft Dynamics 365 | Integration, Dataverse...
Suggested answer

Data Entity Export

Posted on by Microsoft Employee

Hello Everyone,

I created an entity in D356 and whenever i export this entity in Azure SQL DB it gives the following error:

"Export execution failed for entity EntityName: Export failed while copying data from staging to target:"

But whenever i republish the entity and export it, it exports successfully. What does publish exactly do?

Can anyone please help?

Regards

Export_5F00_Log.PNG

  • Suggested answer
    Ajit Profile Picture
    Ajit 8,755 on at
    RE: Data Entity Export

    You don't have to republish all the time before exporting the data. Are you pushing full all the time? or it fails when you run incremental? Also check the mapping in your data project.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Data Entity Export

    Hi,

    Thank you Fangyuan, But why do i always have to republish before export?

    What could be the issue?

    Regards,

  • Suggested answer
    Fangyuan Hou Profile Picture
    Fangyuan Hou on at
    RE: Data Entity Export

    Hi,

    Republish the entity will truncate the table in the external Azure SQL DB and recreate the table with the correct schema. 

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,056 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans