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

Join the FabCon + SQLCon recap series. Up next: Power BI, Real-Time Intelligence, IQ and AI, and Data Factory take center stage. All sessions are available on-demand after the live show. Register now

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
April Power BI Update Carousel

Power BI Monthly Update - April 2026

Check out the April 2026 Power BI update to learn about new features.

New to Fabric survey Carousel

New to Fabric Survey

If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.

FabCon and SQLCon Highlights Carousel

FabCon &SQLCon Highlights

Experience the highlights from FabCon & SQLCon, available live and on-demand starting April 14th.