Error: Input DataSet must contain keycolumn(s) in Upsert/Update scenario. Missing key column(s) in Microsoft Azure Data Factory

Azure Data Factory and CRM

Continue reading

Azure: Copy Data from CSV file to D365 instance using Azure Data Factory

Ajit Patra

In this post, we’ll see how to upload data in CSV file to D365 instance using Azure Data Factory. We’ll need following Azure resources for this demo:

  1. Azure Data Factory
  2. Blob Storage

Let’s go through the below steps to see it in action:

  • Login to Azure Portal
  • Click on Create a resource –> Select Storage –> Select Storage Account

b

  • Select Resource Group –> Give a valid name for the storage account –> Click Next:Advanced

c

  • Click on Next: Tags

d

  • Click on Next: Review + Create

e

  • Once the Validation passed message is displayed, Click on Create.

f

  • Browse through the storage account created –> Click on Blobs

g

  • Click on +Container to create a container.

h

  • Give a valid name to the blob container –> click on OK

i

  • Browse through the blob container created –> Click on Upload to upload the CSV file for Contact

j

  • Browse the CSV file to upload and click on

View original post 504 more words