Forum Discussion
Power BI Desktop with Password Encrypted Excel File
Hi, I can't connect to an Excel file located under SharePoint (using "SharePoint folder" option and typing the URL of the Excel file as per instructions to connect using Power BI Desktop.
Error message is « "Microsoft.Mashup.Engine1.Library.Resources.HttpResource: Request failed:
OData Version: 3 and 4, Error: The remote server returned an error: (404) Not Found. (Not Found)
OData Version: 4, Error: The remote server returned an error: (404) Not Found. (Not Found)
OData Version: 3, Error: The remote server returned an error: (404) Not Found. (Not Found)" »
Anyone can advise on how to resolve this ?
Hi demem106 ,
PowerBI still cannot import the password-protected excel files as a dataset, please refer to this idea: https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/9422748-connect-to-password-protected-excel-workbook.
As a workaround, we can use Python script to read the encrypted Excel file, PowerBI can use Python script, https://stackoverflow.com/questions/3783980/how-to-read-password-protected-excel-in-python.
Best Regards,
Teige
1 Reply
Hi demem106 ,
PowerBI still cannot import the password-protected excel files as a dataset, please refer to this idea: https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/9422748-connect-to-password-protected-excel-workbook.
As a workaround, we can use Python script to read the encrypted Excel file, PowerBI can use Python script, https://stackoverflow.com/questions/3783980/how-to-read-password-protected-excel-in-python.
Best Regards,
Teige