Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
Sairam_11
Frequent Visitor

Import Excel Workbook - Error

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

SaiScreenshot (14).png

1 ACCEPTED SOLUTION
Anonymous
Not applicable

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.

View solution in original post

2 REPLIES 2
Anonymous
Not applicable

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
Frequent Visitor

Hello All,

The issue was with encrpting the excel file with a password

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

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors