Forum Discussion
Getting error "We don't support reading encrypted workbooks." while refreshing dataset
Hello, I have a dataset that takes data from multiple Excel files in a Sharepoint folder. Recently I'm not able to refresh it as I get the following error message "We don't support reading en...
Hi Anonymous ,
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