Unanswered

Syncing Dataverse Data into Azure SQL using ADF

(0) Share

Report

Posted on by wajih

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

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (2)

Answers (0)

AhmedSalih

6,678 Moderator on at

Like (0)

Report

Hello, @qidwai, have you enabled the Track Changes property in you Dataverse Tables?

If my reply helped you, please give a 👍 , & if it solved your issue, please 👍 & Accept it as the Solution to help other community members find it more.

I am primarily available on weekdays from 6-10 PM CT and 5-10 PM CT on weekends.

Visit my Blog: www.powerplatformplace.com

Was this reply helpful? Yes No

wajih 6 on at

Like (0)

Report

Hi Ahmed,
Yes, this is all set as I was using the same instance with DES and data is synced in Data Lake without any issue, but when using ADF and running pipeline the error is thrown at that stage as per the below image. I have tried deleting all the tables from Database as well

Was this reply helpful? Yes No