Power BI

Needs Votes

Connect to password protected excel workbook

Vote (1026)

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 (103)

Comments (103)

Christopher Hoffman on 27 Nov 2024 19:38:51

RE: Connect to password protected excel workbook

I understand that one option is to protect the file via User Access, HOWEVER there are plenty of use cases where temporary access is required. It is much easier to give someone the password for a short term and quick update than to submit a ticket for IT to giveth then taketh away. Honestly, if you're not going to support password protection because of user access control then you should completely remove the option to password protect a file. Tell us when a feature should not be used so we can change and move on. SMH.To build upon WHY this is useful, just because a file is password protected that does not - repeat, DOES NOT, mean the data is sensitive. Even if I do not know the password there is an option to open the file read-only. The password is in place so derps do not go in and start editing the file. I need to extract data via Power Query, which is already READ ONLY. It's absurd that I can open a file read only copy of the password protected file myself, but if I wanted to query that data read-only I have to enact some silly secret workaround ritual.