Resolving Encrypted Excel File Error in Azure Data Factory

Question

How can I resolve the error "Encrypted excel file is not supported" in Azure Data Factory when copying data from Azure Storage to Snowflake?

PS - Based on common issues that we have seen from customers and other sources, we are posting these questions to help the Azure community.

Answer 1

Greetings!

The error "Encrypted excel file is not supported" occurs when Azure Data Factory (ADF) attempts to process an encrypted Excel file. To resolve this issue, you need to remove the password encryption from the Excel file. Follow these steps:

1. Open the encrypted Excel file and remove its password.
2. Save the file without encryption and re-upload it to Azure Storage.
3. Update the source dataset in ADF with the correct file path.
4. Ensure the target details are specified correctly in the sink dataset.

After performing these steps, you may encounter another error: "SQL compilation error: Schema does not exist or not authorized." This error occurs due to the absence of the specified schema in the target Snowflake database. To resolve this:

1. Verify that the schema exists in the Snowflake target.
2. Ensure that the necessary permissions are granted for accessing the schema.

The customer in this case resolved the issue by consulting with their internal Snowflake team and obtaining the required permissions.

Resources:

• Azure Data Factory Copy Activity Overview
• Snowflake Documentation: Managing Access Control

Hope this helps. If you have any follow-up questions, please let me know. I would be happy to help.

Please do not forget to "up-vote" wherever the information provided helps you, as this can be beneficial to other community members.