Bulk insert into Dataverse using ADF

Question

Bulk insert into Dataverse using ADF

Chettiyattil Dharman, Mithun 5

Is there a way we can do Bulk Insert or Insert only into Dataverse table using ADF . At present i can see only "Upsert" option while copying the data to Dataverse.

KranthiPakala-MSFT 46,642 Reputation points Microsoft Employee Moderator

2023-05-04T00:05:53.1833333+00:00

@Chettiyattil Dharman, Mithun Just checking in to see if the below information was helpful. If it answers your query, please do click Accept Answer and Yes for "was this answer helpful", as it might be beneficial to other community members reading this thread. If you have any further query, do let us know.

Thank you
KranthiPakala-MSFT 46,642 Reputation points Microsoft Employee Moderator

2023-05-05T23:33:00.5533333+00:00

@Chettiyattil Dharman, Mithun We still have not heard back from you. Just wanted to check if the below information was helpful? If it answers your query, please do click Accept Answer and Yes for "was this answer helpful", as it might be beneficial to other community members reading this thread. And, if you have any further query do let us know.

Thank you

1 answer

Your answer

KranthiPakala-MSFT 46,642 Reputation points Microsoft Employee Moderator

2023-05-04T00:05:53.1833333+00:00

@Chettiyattil Dharman, Mithun Just checking in to see if the below information was helpful. If it answers your query, please do click Accept Answer and Yes for "was this answer helpful", as it might be beneficial to other community members reading this thread. If you have any further query, do let us know.

Thank you
KranthiPakala-MSFT 46,642 Reputation points Microsoft Employee Moderator

2023-05-05T23:33:00.5533333+00:00

@Chettiyattil Dharman, Mithun We still have not heard back from you. Just wanted to check if the below information was helpful? If it answers your query, please do click Accept Answer and Yes for "was this answer helpful", as it might be beneficial to other community members reading this thread. And, if you have any further query do let us know.

Thank you

Answer 1

Hi @Chettiyattil Dharman, Mithun ,

Welcome to Microsoft Q&A forum and thanks for reaching out here.

If you are using copy activity, then only upsert operation is available and it is a required field.

User's image

If your requirement is to insert only, then you can use mapping data flow activity, in which you have other operations (including insert) supported.

User's image

If you have any feature request feedback for copy activity - Dataverse connector, please feel free to log it in IDEAS forum here: https://feedback.azure.com/d365community/forum/1219ec2d-6c26-ec11-b6e6-000d3a4f032c All the feedback shared in this forum are actively monitored and reviewed by respective product owners. Kindly share the feedback URL once it is logged so that we can share it with internal team for further review.

Hope this info helps.

Please don’t forget to Accept Answer and Yes for "was this answer helpful" wherever the information provided helps you, this can be beneficial to other community members.

Share via

Bulk insert into Dataverse using ADF

1 answer

Your answer