How to fix "ErrorCode=EncryptedExcelIsNotSupported"


Hi I´m Trying to make a pipeline with a copydata activity conected to a sharepoint as source with a Token: User's image

The main issue is that even if I have already add the permission in the sharepoint site and in the Azure Active Directory (app registration) it doesn't let me access to the excel file , the error says that the excel file has a password but I have already checked it out and it does not have a password or some security.

User's image

ann in the follow image it says that the protection is disabled

User's image

I need to access to that file to get the data,I have tried with .xlsx, .xlsb and .csv.

what can I do ?

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
8,445 questions
{count} votes

1 answer

Sort by: Most helpful
  1. KranthiPakala-MSFT 45,652 Reputation points Microsoft Employee

    @Falcón,Ricardo,MX-Ciudad de México


    I just heard back from the product team that the sensitivity settings of the file to be changed to general inorder to overcome the issue. Then the copy activity would work as expected. 

    For example change the sensitivity label of the file to general as shown below and save it.

    User's image

    For more info about sensitivity label settings, please refer to this document: Apply sensitivity labels to your files and email


    Hope this helps.


    Please don’t forget to Accept Answer and Yes for "was this answer helpful"  wherever the information provided helps you, this can be beneficial to other community members.

    1 person found this answer helpful.