Skip to main content

Power BI

Needs Votes

Connect to password protected excel workbook

Vote (1025) 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

Faouzi Moueffek on 06 Jul 2020 00:02:14

RE: Connect to password protected excel workbook

It's a must now with all the new Data Privacy regulations

Trav's profile image Profile Picture

Christian on 06 Jul 2020 00:01:26

RE: Connect to password protected excel workbook

'+1

Trav's profile image Profile Picture

Matthew Montgomery on 06 Jul 2020 00:01:19

RE: Connect to password protected excel workbook

This is a four year old idea that I support.

Trav's profile image Profile Picture

SuperMike on 06 Jul 2020 00:00:06

RE: Connect to password protected excel workbook

'+1

Trav's profile image Profile Picture

SuperMike on 06 Jul 2020 00:00:06

RE: Connect to password protected excel workbook

And also restricted Excel Files (using domain users)

Trav's profile image Profile Picture

Mehdi HAMMADI on 05 Jul 2020 23:59:47

RE: Connect to password protected excel workbook

This is a must needed.

Trav's profile image Profile Picture

JW on 05 Jul 2020 23:58:20

RE: Connect to password protected excel workbook

Is really needed to split fx Nordic sensitive data into country specific reports

Trav's profile image Profile Picture

Himanshu Nagpal on 05 Jul 2020 23:58:09

RE: Connect to password protected excel workbook

Power Query / Power BI should ask / or give an option to open a password protected file , If the password is correct it should be able to open it and retrieve data from it . else it should not open it . It is a wonderful tool..
this will be helpful in maintaining sanctity of the data and confidentiality of the File by the users.

Trav's profile image Profile Picture

Rajesh N on 05 Jul 2020 23:57:02

RE: Connect to password protected excel workbook

This functionality is really essential, when we have to work with confidential data

Trav's profile image Profile Picture

richa on 05 Jul 2020 23:56:21

RE: Connect to password protected excel workbook

Yes, we need this functionality.