Forum Discussion

mshilendhari's avatar
mshilendhari
Frequent Visitor
6 years ago
Solved

Password Protected Excel File from SharePoint

Hi,

 

I have a password protected xlsm file hosted in sharepoint on premise site. I need to connect to this file and prepare a report in Power BI. I did Get Data ->Web -> http://sharepointsite/FileName.xlsm I am getting the below error upon connecting.

 

Does Power BI not support connecting to password protected excel files?

 

  • hi, mshilendhari 

    To my knowledge, it is unavailable that connect to password protected excel workbook in power bi currently.

    For your requirement, you may vote for the idea here and make this feature coming sooner.

     

    Best Regards,

    Lin

2 Replies

  • v-lili6-msft's avatar
    v-lili6-msft
    Community Support

    hi, mshilendhari 

    To my knowledge, it is unavailable that connect to password protected excel workbook in power bi currently.

    For your requirement, you may vote for the idea here and make this feature coming sooner.

     

    Best Regards,

    Lin

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hello-

     

       You may be able to do this by choosing the SharePoint connector in "Get data" rather than web.  Please try that and go through the process.  If it does not work, please let us know!

     

    Jared