Forum Discussion
Power BI Desktop with Password Encrypted Excel File
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
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