Skip to main content

Power BI

Needs Votes

Connect to password protected excel workbook

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

Alexandre Robidel on 12 Aug 2022 09:56:16

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...

Trav's profile image Profile Picture

Andrew Bradley on 27 Jul 2022 14:24:50

RE: Connect to password protected excel workbook

Not helpful to restrict access to sensitive files for reporting purposes, please remove and enable import.

Trav's profile image Profile Picture

Allister B on 27 Jul 2022 09:22:42

RE: Connect to password protected excel workbook

It would also be so good to have this for PQ in Excel too

Trav's profile image Profile Picture

Wilson Wong on 08 Jul 2022 07:50:16

RE: Connect to password protected excel workbook

Please prioritize rolling out this feature, its a pretty essential feature.

Trav's profile image Profile Picture

Philipp Haselmayr on 17 May 2022 12:43:11

RE: Connect to password protected excel workbook

In desperate need of this feature!

Trav's profile image Profile Picture

Pia Haslinger on 17 May 2022 12:35:15

RE: Connect to password protected excel workbook

It would be great if this feature gets worked on. We would really make great use of it!

Trav's profile image Profile Picture

E P on 28 Apr 2022 08:17:36

RE: Connect to password protected excel workbook

We really need this..

Trav's profile image Profile Picture

Shuhei Ueda on 14 Mar 2022 14:10:13

RE: Connect to password protected excel workbook

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.

Trav's profile image Profile Picture

Simon Brock on 25 Feb 2022 07:26:49

RE: Connect to password protected excel workbook

I landed here after a very quick search for 'Power BI password protected Excel'. I cannot believe this is a thing! Surely there should be a way to enter the password in Power BI and convey it securely to the Excel workbook. Needs implementing!

Trav's profile image Profile Picture

Frank Gonzalez-Morphy on 12 Feb 2022 13:40:04

RE: Connect to password protected excel workbook

As Excel and PowerBI are from the same company, it should be possible to have a field for "Password", so PowerBI could via API or something similar pass the required code. See "avanced" options of excel sheet importing dialog ... https://community.powerbi.com/t5/image/serverpage/image-id/252030i14BF4B6ECFA9F088/image-size/large?v=v2&px=999