Skip to main content

    Power BI

    Needs Votes

    Add connection to password protected MDB-ACCDB Microsoft Access Database

    Vote (293) Share
    Edgar Gerardo Chinchilla M's profile image

    Edgar Gerardo Chinchilla M on 03 Nov 2015 03:46:02

    Please add support to connect to a password protected MDB-ACCDB MS Access Databse

    Comments (73)
    Edgar Gerardo Chinchilla M's profile image Profile Picture

    Reilly Miller on 05 Jul 2020 23:26:14

    RE: Add connection to password protected MDB-ACCDB Microsoft Access Database

    Just wanted to add a workaround for those who still need this. You can create an ODBC connection to your access database (just search ODBC in your start menu) then use the following string in a query to connect:

    Source = Odbc.DataSource("arbitraryname,pwd=yourpassword;dsn=ODBCConnectionName", [HierarchicalNavigation=true])

    Edgar Gerardo Chinchilla M's profile image Profile Picture

    Aurian on 05 Jul 2020 23:24:56

    RE: Add connection to password protected MDB-ACCDB Microsoft Access Database

    Great idea !

    Edgar Gerardo Chinchilla M's profile image Profile Picture

    Nick on 05 Jul 2020 23:23:36

    RE: Add connection to password protected MDB-ACCDB Microsoft Access Database

    Still waiting! Any updates?

    Edgar Gerardo Chinchilla M's profile image Profile Picture

    Liv on 05 Jul 2020 23:19:47

    RE: Add connection to password protected MDB-ACCDB Microsoft Access Database

    Would be a great thing to add!

    Edgar Gerardo Chinchilla M's profile image Profile Picture

    Benjamin on 05 Jul 2020 23:18:25

    RE: Add connection to password protected MDB-ACCDB Microsoft Access Database

    how can that not be already included? basic requirement!!!!!

    Edgar Gerardo Chinchilla M's profile image Profile Picture

    NCL on 05 Jul 2020 23:17:15

    RE: Add connection to password protected MDB-ACCDB Microsoft Access Database

    I don't know why that is not a function included. both are your products

    Edgar Gerardo Chinchilla M's profile image Profile Picture

    Power BI User on 05 Jul 2020 23:16:55

    RE: Add connection to password protected MDB-ACCDB Microsoft Access Database

    This is very important feature that is hindering PBI progress.

    Edgar Gerardo Chinchilla M's profile image Profile Picture

    Power BI User on 05 Jul 2020 23:16:15

    RE: Add connection to password protected MDB-ACCDB Microsoft Access Database

    Need this feature in Power BI

    Edgar Gerardo Chinchilla M's profile image Profile Picture

    Power BI User on 05 Jul 2020 23:12:54

    RE: Add connection to password protected MDB-ACCDB Microsoft Access Database

    Please I need this or an alternate

    Edgar Gerardo Chinchilla M's profile image Profile Picture

    Pepe Paco on 05 Jul 2020 23:12:32

    RE: Add connection to password protected MDB-ACCDB Microsoft Access Database

    I'm surprised I cannot conect to a MS Access password protected from Power BI. Why?