Skip to main content
Microsoft Idea

Power BI

Needs Votes

Connect to password protected excel workbook

Vote (957) 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 (96)
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


Trav's profile image Profile Picture

Eric Klamm on 11 Feb 2022 18:45:16

RE: Connect to password protected excel workbook

This is a needed feature. If you have the password it should be an option to enter it upon connection, similar to connecting to SQL or any other authenticated connection

Trav's profile image Profile Picture

Garazi Donlo on 01 Feb 2022 15:23:44

RE: Connect to password protected excel workbook

Absolutely essential! This is the pain of my life right now...

Trav's profile image Profile Picture

Stephan Song on 26 Dec 2021 15:40:44

RE: Connect to password protected excel workbook

This would be super good if this functionality is available in Power Query.

This is the worst thing I have encountered that I can not open a password protected file with Power Query.

Trav's profile image Profile Picture

Shadi Abu Okkaz on 17 Dec 2021 06:12:29

RE: Connect to password protected excel workbook

It is really a crucial need, and if it was applied on all types of protected file types that would be a very important addition to the Power BI desktop, and of course at first the password should be available to be provided.

Trav's profile image Profile Picture

Matthew Steede on 27 Oct 2021 15:39:30

RE: Connect to password protected excel workbook

Yes please!

Trav's profile image Profile Picture

JP Guerra on 02 Oct 2021 00:01:17

RE: Connect to password protected excel workbook

Within the corporate environment, this is definitely needed.

Trav's profile image Profile Picture

Derek Kelly on 07 Jul 2021 04:17:42

RE: Connect to password protected excel workbook

This feature is badly needed!