Share via

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.
10,964 questions

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Dillon Silzer 57,456 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
  2. Pratik Somaiya 4,206 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

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.