Trav on 21 Aug 2015 09:38:21
It would be great if we can connect or open the password protected excel workbook inside Power BI Desktop. Of course we should know & provide the password first.
- Comments (98)
RE: Connect to password protected excel workbook
Please make an update for this!
RE: Connect to password protected excel workbook
I agree, really need.
RE: Connect to password protected excel workbook
This seems pretty basic and pretty essential. Need to have the ability to prevent people from changing data in excel, but still access it for report building and auto-refresh. Especially since these are both microsoft tools.
RE: Connect to password protected excel workbook
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!
RE: Connect to password protected excel workbook
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.
RE: Connect to password protected excel workbook
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...
RE: Connect to password protected excel workbook
Not helpful to restrict access to sensitive files for reporting purposes, please remove and enable import.
RE: Connect to password protected excel workbook
It would also be so good to have this for PQ in Excel too
RE: Connect to password protected excel workbook
Please prioritize rolling out this feature, its a pretty essential feature.
RE: Connect to password protected excel workbook
In desperate need of this feature!