My company just made it compulsory to mark all files in Office 365 with Confidential and as a effect this encrypts the file (similar to password protection). Now our finance teams can either comply with the measure and break Power Query (for Power BI or Excel) or mislabel workbooks. The sooner this one can be solved the better!
Please implement this feature asap, it is very important to encrypt confidential data but at the same time we need to be able to use these data for analysis.
It would be very important to me to add this functionnality to Power Query. I needed to remove password from all my files to be able to use PQ on them...
Not helpful to restrict access to sensitive files for reporting purposes, please remove and enable import.
It would also be so good to have this for PQ in Excel too
Please prioritize rolling out this feature, its a pretty essential feature.
In desperate need of this feature!
It would be great if this feature gets worked on. We would really make great use of it!
We really need this..
I am also facing the same issue... I am sure a lot of company wants a dashboard off of a locked spreadsheets... Especially from Sharepoint and OneDrive... Like ask for a password before open/edit.