Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics 365 | Integration, Dataverse...
Unanswered

Copying Dataverse Data into Azure SQL using ADF

(0) ShareShare
ReportReport
Posted on by 34

Hi, 

I am following https://learn.microsoft.com/en-us/power-apps/maker/data-platform/azure-synapse-link-pipelines?tabs=data-factory this Microsoft document to copy data from Dataverse to Azure SQL to replace Data Export Service. However, I am having error that Object already exist or even if I remove all the tables and they try it then its showing "Activity failed because an inner activity failed; Inner activity name: CreateTable, Error: Column names in each table must be unique. Column name 'Id' in table  is specified more than once" but this is not the case. Any idea

Thanks

Wajih

  • Martin Dráb Profile Picture
    Martin Dráb 230,445 Most Valuable Professional on at
    RE: Copying Dataverse Data into Azure SQL using ADF

    Microsoft Dataverse forum would be a better place such questions than Dynamics 365 General Forum.

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!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,445 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans