Does Azure Data Factory support Many to Many table copy to Dataverse?

Sandeep009 1 Reputation point

Hi Team,

Does Azure Data Factory support Many to Many Table data copy to Dataverse?

I have followed the below steps:

  1. Using ADF, imported Table1 - Employee
  2. Using ADF, imported Table 2 - Training
  3. Using ADF, when I try to import the Intermediate table (Employee_Training), I am getting the below error:

ErrorCode=DynamicsOperationFailed,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Dynamics operation failed with error code: -2147219456, error message: The 'Create' method does not support entities of type 'pp_training_employee'. MessageProcessorCache returned MessageProcessor.Empty. .,Source=Microsoft.DataTransfer.ClientLibrary.DynamicsPlugin,''Type=System.ServiceModel.FaultException`1[[Microsoft.Xrm.Sdk.OrganizationServiceFault, Microsoft.Xrm.Sdk, Version=, Culture=neutral, PublicKeyToken=31bf3856ad364e35]],Message=The creator of this fault did not specify a Reason.,Source=Microsoft.DataTransfer.ClientLibrary.DynamicsPlugin,'

Any suggestion?

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
7,150 questions
{count} votes

3 answers

Sort by: Most helpful
  1. Nithin Chitiki 6 Reputation points

    you can follow the links below :

    You need some external tools to help you manage NN relationship. I recommend you to use XrmToolBox plugin for Importing N:N relationships.

    XrmToolBox :

    Manage NN relationships:

    1 person found this answer helpful.
    0 comments No comments

  2. Jason Mcneil 6 Reputation points

    I know this is from a while back, but we faced a similar challenge recenltly, and we used ADF but instead of a Copy Task we had it use an HTTP activity and had it call the Dataverse Web API with the right arguments to associate records - took a bit of fiddling to get the connection right, but works great

    1 person found this answer helpful.
    0 comments No comments

  3. Nithin Chitiki 6 Reputation points

    Hi @Sandeep009 . I have been in a similar scenario where in many to many relationships the data will be sitting in a intermediate table, and when you try to populate with the ADF it wont support, and my suggestions is to use XRM tool box where you can populate the table that has many to many relationship.

    0 comments No comments