Uanble to read excel file from SFTP server in Azure ADF

siya1234 1 Reputation point
2022-10-01T22:18:08.103+00:00

Error details
Error code
21359
Details
Encrypted excel file 'SAMPLE.XLSX' is not supported, please remove its password.
Wrong Local header signature: 0x41D
Activity ID: 70462da3-07e6-4d98-8373-85bdbb0fe9bc

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

2 answers

Sort by: Most helpful
  1. Dillon Silzer 54,831 Reputation points
    2022-10-01T22:36:35.093+00:00

    Hi @siya1234

    I'd probably follow the error Encrypted excel file 'SAMPLE.XLSX' is not supported, please remove its password.. Try placing a SAMPLE.XLSX on your SFTP Server that is not encrypted and try to reconnect ADF.

    -----------------------------

    If this is helpful please accept answer.

    0 comments No comments

  2. Pratik Somaiya 4,201 Reputation points
    2022-10-03T06:42:05.523+00:00

    Hello @siya1234

    As said by @Dillon Silzer , first check if the file is encrypted and has a password, if yes then remove it and then place it again on SFTP

    Currently, ADF will not support decrypting a password protected file, but if that is your requirement, you will either have to use a different component like Azure Function

    You can find more details in a similar type of question here

    0 comments No comments