Forum Discussion
Hidden Excel Sheets when importing multiple excels from a sharepoint folder
Hi Anonymous ,
Sorry for that 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.
Best regards,
Community Support Team _ zhenbw
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous , I doubt that is possible
https://community.powerbi.com/t5/Desktop/Password-Protected-Excel-File-from-SharePoint/td-p/804076
amitchandakThanks for your reply! The password is no problem for now, I can see all the other sheets. Only the Excel structure is protected with a password, the data isn't. It is just that the sheet I need is not visable in all the workbooks.
Hi Anonymous ,
Sorry for that 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.
Best regards,
Community Support Team _ zhenbw
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.