Password Protected Excel File from SharePoint

[mshilendhari]

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?

[v-lili6-msft · Accepted solution]

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]

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