Skip to main content

    Power BI

    Needs Votes

    Connect to password protected excel workbook

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

    2d8fbe0c 5779-45c9-aaa2-8c3a114f52f9 on 05 Jul 2020 22:15:16

    RE: Connect to password protected excel workbook

    Yes I need it.!!

    Trav's profile image Profile Picture

    52ca36d0 5ad0-4c3f-94bb-3e700d34ac59 on 05 Jul 2020 22:13:13

    RE: Connect to password protected excel workbook

    Essential for the analysis of confidential data. I currently get the following error which disappear once the password has been removed
    Details: "Excel Workbook: The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine. The 64-bit version of the Access Database Engine 2010 Access Database Engine OLEDB provider is required to connect to read this type of file. To download the client software, visit the following site: https://go.microsoft.com/fwlink/?LinkID=285987."