News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics 365 | Integration, Dataverse... Data Entity Export

Microsoft Dynamics 365 | Integration, Dataverse...

Suggested answer

Data Entity Export

(0) Share

Report

Report

Posted on by Community Member 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

All responses Img

All responses (3)

Answers Img

Answers (0)

Suggested answer

Ajit 8,755 on at

Like (0)

Report

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 Microsoft Employee on at

Like (0)

Report

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 on at

Like (0)

Report

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.

Helpful resources

Quick Links

Leaderboard

#1

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

#2

Martin Dráb 230,445 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Get batch job history log from D365 FO to Power Automate

Product updates

Dynamics 365 release plans