Import Excel Workbook - Error

[Sairam_11]

Hello All,

Trying to import a workbook from a common pathway but there is an unidentified error.

Any quick suggestions on why does it fail?

Thanks

Sai

[v-yangliu-msft · Accepted solution]

Hi  @Sairam_11 ,

It seems that Power Bi desktop doesn't support to fetch data from password protected Excel file. Here is an idea you could click to vote it up.

As a workaround, you could remove passsword and instead, move the files to a secure folder that limited people have access to.
Reference: power query accessing password protected workbook

Solved: Using an Excel Workbook protected by Information R... - Microsoft Power BI Community

Power BI Issue Fix: Import from Excel Workbook Contents; Password Protection Failure - RADACAD

Best Regards,

Liu Yang

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

[Sairam_11]

Hello All,

The issue was with encrpting the excel file with a password

Can't we import an encrypted file in Power BI?