Skip to main content

Power BI

Needs Votes

Connect to password protected excel workbook

Vote (1027) Share
Trav's profile image

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)
Trav's profile image Profile Picture

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.

Trav's profile image Profile Picture

Felipe Gutnik on 24 Jun 2024 13:10:46

RE: Connect to password protected excel workbook

Not having this feature dramatically increases the complexity of accessing password protected spreadsheets!

Trav's profile image Profile Picture

Riaz Khoja on 20 Jun 2024 18:34:05

RE: Connect to password protected excel workbook

Please provide support to load a password protected excel file to power BI

Trav's profile image Profile Picture

伸隆 日野 on 30 May 2024 07:26:27

RE: Connect to password protected excel workbook

早く実現して欲しい

Trav's profile image Profile Picture

antoni bosco on 18 Apr 2024 12:26:42

RE: Connect to password protected excel workbook

I was looking for it, thanksHackear Instagram

Trav's profile image Profile Picture

Antonio Rocha on 09 Apr 2024 12:58:04

RE: Connect to password protected excel workbook

Hello

Trav's profile image Profile Picture

Pat Toohey on 19 Mar 2024 19:38:44

RE: Connect to password protected excel workbook

Let me in I know the password! How can this not be a feature already!

Trav's profile image Profile Picture

Jeremy Suelflow on 28 Feb 2024 05:37:35

RE: Connect to password protected excel workbook

Yes. Almost 9 years later, this is still as relevant as ever!

Trav's profile image Profile Picture

Francisco Balança Lopes on 26 Jan 2024 12:46:12

RE: Connect to password protected excel workbook

This feature is very important to protect our data and keep our reports safe. Please make this happen

Trav's profile image Profile Picture

Jacob Holk Pedersen on 10 Jan 2024 08:05:02

RE: Connect to password protected excel workbook

Would make working with sensitive information so much easier