Connect to password protected excel workbook

[xrmtrav]

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.

[Stephan_Song2]

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.

[DonloG]

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

[EK103]

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

[Frank_Gonzalez-]

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

[simon_brock]

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!

[shuhei1]

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.

[Eshan_Pacheriwa]

We really need this..

[Pia_Haslinger]

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

[Philipp_Haselma]

In desperate need of this feature!

[Wilson_Wong]

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