Dynamically copying all types of files, including Excels, JSON, CSV, and TXT, using a single copy data activity in ADF

The objective is to copy various types of files, including JSON, CSV, Text, and Excel files, using a single Copy data activity in Azure Data Factory (ADF) pipeline. Implementation: Step 1: Utilize the “Get Metadata” activity to retrieve the list of files stored in the blob storage. Select the “Child Items” option from the field… Continue reading Dynamically copying all types of files, including Excels, JSON, CSV, and TXT, using a single copy data activity in ADF

Dynamics 365 Sales data import. Anomalous materials and unforeseen consequences

We all have imported data into CRM at some point in our life. And a part of the process of importing data is cleaning up the data the is to be imported. I am sure almost all of us have encountered some unusual data that we had to clean up and some unusual data that looks… Continue reading Dynamics 365 Sales data import. Anomalous materials and unforeseen consequences