Can you extract data from an Excel Workbook using Azure Data Factory that has Azure Information Protection

Question

I have an internal document (Excel) that has an Azure information Protection / O365 Unified Sensitivity Labelling applied to it.

Im trying to extract that data, but I'm getting an Encryption Error because and rightly so the information is encrypted.

The process: The document is pulled from Sharepoint into a blob storage container and then Azure Data factory picks up the file using the Copy activity and reads the contents into an Azure SQL Database

Error message: ErrorCode=EncryptedExcelIsNotSupported,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Encrypted excel file 'dummy file.xlsx' is not supported, please remove its password.,Source=Microsoft.DataTransfer.ClientLibrary,''Type=ICSharpCode.SharpZipLib.Zip.ZipException,Message=Wrong Local header signature: 0xE011CFD0,Source=ICSharpCode.SharpZipLib,'

I have a Linked Service using a Service principal that can connect to the file, but previewing the data results in a message saying the file is encrypted.

I presume I would need to give permissions to the Service Principal, but im still stuck what those would be. I tried adding Azure Rights Management read/create in the API permissions but that still hasn't worked

Answer 1

Data Factory can't read the file data which is protected by other service.

If you want to copy data from the encrypted files, you must have the permission to access it.