Why ADF copy activity skips .xlsx files?

Salomon Henriquez 106 Reputation points Microsoft Employee
2024-07-17T20:58:38.59+00:00

Whe running a copy activity in ADF, the copy runs fine and gets done with no errors. I see 5 files are skipped. These are "xlsx"files. The "skip incompatile rows" option is disable in my setttings.
This copy runs from Amazon S3 compatible storage system to Azure blob.

Any idea or suggestion will be highly appreciated.

Thanks in advance.

Azure Blob Storage
Azure Blob Storage
An Azure service that stores unstructured data in the cloud as blobs.
2,919 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,832 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Amira Bedhiafi 26,261 Reputation points
    2024-07-17T22:03:04.2833333+00:00

    When the Fault Tolerance feature is enabled in ADF, it skips rows that don't match the destination dataset schema.

    Check the logs on Azure Blob Storage for incompatible rows to identify the cause of the failure. It seems the rows skipped in the first run were not corrected at the data source, causing them to be skipped again.

    https://learn.microsoft.com/en-us/azure/data-factory/copy-activity-fault-tolerance#copying-tabular-data


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.