Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,631 questions
Data factory Excel file read error
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(185.6, 67%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
Suman
6
Reputation points
The Excel file is loading into the Blob storage through the HTTP connector(Binary copy) and this process works fine. However when I tried to consume the file through the Blob excel dataset then I am getting the below error
"Schema import failed: Encrypted excel file '****.xlsx' is not supported, please remove its password.\r\nWrong Local header signature: 0x5B8399\r\n Activity ID: 8123b213-3172-4ae0-b854-6f8be4307207"
The file is generated from the HTTP connector is not encrypted. I have tried downloading this file to my local drive and I can open this with Excel without any error. I have also tried to upload this file from my local drive to Blob storage and this file works with the Data Factory dataset.
Any inputs will be appreciated.
Azure Data Factory
{count} vote
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(134.4, 9%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKM%3C/text%3E%3C/svg%3E)
KranthiPakala-MSFT 46,642 Reputation points Microsoft Employee Moderator2021-08-24T07:58:26.367+00:00 Hi @Suman ,
Welcome to Microsoft Q&A forum and thanks for reaching out.
Could you please clarify on this statement
*I have also tried to upload this file from my local drive to Blob storage and this file works with the Data Factory dataset*Does it mean it you download and upload the Excel file generated by HTTP connector to a Blob storage and use it in ADF then you are not seeing any issues and file process successfully, but if you use the direct file from the source location, is it throwing the above error? -
Suman 6 Reputation points
2021-08-24T08:21:53.113+00:00 Sorry, I should have been clear in my earlier post. If I rename the file and re-upload it to the Blob storage then it works.
- Generate the file to Blob storage through HTTP connector
- Download it to a local drive
- Open with Excel
- Rename the file
- Upload to Blob storage
-
KranthiPakala-MSFT 46,642 Reputation points Microsoft Employee Moderator
2021-08-24T08:27:46.667+00:00 Data Factory can't read the file data which is protected by other service. Could you please check if the excel is set as
Sensitivity. Any confidential files are not supported.
-
Suman 6 Reputation points
2021-08-24T09:15:04.517+00:00 I don't see any sensitivity labels applied to the file.
Sign in to comment
Sign in to answer