Skip to main content
Microsoft Idea

    Power BI

    Needs Votes

    Connect to password protected excel workbook

    Vote (970) 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 (98)
    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


    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!