Forum Discussion

Lora9999's avatar
Lora9999
Frequent Visitor
1 year ago

Error when Importing Excel via SharePoint Folder Connector in Power BI

Hello,

 

I am trying to import an Excel using the SharePoint folder connector, but I keep encountering the following error.

 

DataSource.Error: Credentials are required to decrypt this workbook, but none were provided. Details: Path=https://aaworkplace.sharepoint.com/sites/aaaaaaaaaaaaaa ErrorMessage=Client application failed to provide authentication token for HTTP request., CorrelationId=1e908cec-914a-427a-bf51-9b64d27d9a6a, CorrelationId.Description=PolicyProfile

 

I thought it would be a simple process of authentication with my MS account, but this error persists.
Is there a way to resolve this issue?

 

Is there anything I should check regarding permissions or file security?

I can view the excel on SharePoint, so I assume I have the necessary permissions.

The excel has a sensitivity label applied—could this be related to the issue?

 

I need your help.

Need Help

9 Replies

  • danextian's avatar
    danextian
    Icon for Super User rankSuper User
    1 year ago

    Hi Lora9999 

     

    Are you able to access the folder itself in SharePoint and not just the Excel file?

      • danextian's avatar
        danextian
        Icon for Super User rankSuper User
        1 year ago

        Just open the Sharepoint  Folder you are trying  to access with Power BI in a browser.

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi Lora9999 ,

     

    Thanks danextian  for the quick reply. I have some other ideas to add:

    During my investigation I have found users in the past who have had similar experiences to you .
    The solution given by other forum users are:

    (1)Remove the password protection from excel file

    (2)Remove sensitivity label on your source files

    Original post please refer: Solved: Power BI Desktop says "Credentials are required to... - Microsoft Fabric Community

     

    Best Regards,

    Neeko Tang

    If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly. 

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi Lora9999 ,

     

    Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it. Or if you are still confused about it, please feel free to let me know.

     

    Best Regards,

    Neeko Tang