Forum Discussion
Getting error "We don't support reading encrypted workbooks." while refreshing dataset
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
Thx for the answer,
Actually on PBI desktop, the resfresh is working fine, it's when i tried to refresh it directly on app.powerbi.com.
The excel are not protected by password, so I don't think the issue is here.
And everything was working fine until recently this week but the error "We don't support reading encrypted workbooks." doesnt help me to understand and pinpoint what went wrong in the data refresh.