Skip to main content

Power BI

Needs Votes

Connect to password protected excel workbook

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

Elke Hammerl on 17 May 2023 13:22:50

RE: Connect to password protected excel workbook

This would really usefull

Trav's profile image Profile Picture

on 24 Apr 2023 08:08:48

RE: Connect to password protected excel workbook

This feature is a MUST; otherwise how can we use excel from Power Automate with a minimum security?

Trav's profile image Profile Picture

Heidi Croft on 19 Feb 2023 17:35:37

RE: Connect to password protected excel workbook

I somewhat expect to have issues connecting to Salesforce or other non-Microsoft products. But it unbelievable to me that we cannot connect to excel files if they have a password or if they are .xlsb. How was this missed?

Trav's profile image Profile Picture

Carl Kalbfleisch on 16 Feb 2023 21:01:23

RE: Connect to password protected excel workbook

Would really like to have this available in Power BI Dataflow to be able to read password protected Excel

Trav's profile image Profile Picture

Matthew Yin on 14 Feb 2023 00:26:02

RE: Connect to password protected excel workbook

Please make an update for this!

Trav's profile image Profile Picture

Yumna Alya on 08 Feb 2023 04:36:02

RE: Connect to password protected excel workbook

I agree, really need.

Trav's profile image Profile Picture

Anthony Pisano on 12 Jan 2023 18:30:48

RE: Connect to password protected excel workbook

This seems pretty basic and pretty essential. Need to have the ability to prevent people from changing data in excel, but still access it for report building and auto-refresh. Especially since these are both microsoft tools.

Trav's profile image Profile Picture

Chris White on 31 Oct 2022 11:51:35

RE: Connect to password protected excel workbook

My company just made it compulsory to mark all files in Office 365 with Confidential and as a effect this encrypts the file (similar to password protection). Now our finance teams can either comply with the measure and break Power Query (for Power BI or Excel) or mislabel workbooks. The sooner this one can be solved the better!

Trav's profile image Profile Picture

Benedict Mah on 16 Aug 2022 02:54:54

RE: Connect to password protected excel workbook

Please implement this feature asap, it is very important to encrypt confidential data but at the same time we need to be able to use these data for analysis.

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