Azure Data Factory. Encrypted is not supported, please remove its password from file extract from source using Azure Logic App

Question

Hello to everyone

I have a big problem with my automation task.

We create an architecture where some collegues send at a defined mail some excel files. At this point Azure logic app will take these files attached and will stored in a blob deleting the oldest files.

Thanks one trigger in ADF, Data Factory will see this event in our blob and will lunch a pipeline where will insert the information in an Azure SQL table.

Here the problem. The file stored by Logic App in a blob are Encrypted

This the error when i try to create a dataset connection in Azure Data Factory. Preview mode

Encrypted excel file 'FV BS.xlsx' is not supported, please remove its password. Wrong Local header signature: 0x6F40227B

Interest thing, i tried to update the same file manually in my storage account and there is not any sort of Encryption. So we can assume is Logic App that apply by default this kind Encryption.

How i can deal with that, my final purpose is be able to connect these file to ADF, so once a create a Dataset i should be able to pass throught the Encryption. How i can do it ? Someone can help me

Thank you so much

Thomas

Answer 1

Azure Logic Apps does not automatically encrypt files that it processes. When Logic Apps moves a file, such as an Excel file attached in an email, to Azure Blob Storage, it does not modify the file or apply any encryption.

Check the actual logic of sending files in your logic app.

If this becomes a problem, a band-aid you can do is perform a simple Azure function in between that removes any encryption.