Forum Discussion
Power BI - Sensitivity Labeling and File Encryption Issues
Hi All,
We are creating PBI reports by using local excel files and some of the excel files downloaded from Microstrategy combine.
When we manually refresh the tables which are imported from local excel file are refreshed properly, however when we try to refresh Microstrategy excel files we are unable to refresh it and showing attached error message.
So Is there any workaround or fixed plan with Power BI to allow encrypted files to be used?
Thanks
Madhu
Hi MadhuKumar ,
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 workbookSolved: 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.
2 Replies
Hi MadhuKumar ,
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 workbookSolved: 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.
Hi Liu Yang,
Thanks for the solution that you have provided. It was helpful to me.
Madhu
