Skip to main content

    Power BI

    Needs Votes

    Add connection to password protected MDB-ACCDB Microsoft Access Database

    Vote (252) 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 (68)
    Edgar Gerardo Chinchilla M's profile image Profile Picture

    a4a4966f 95cd-4f4d-b1c7-06b46bd22712 on 05 Jul 2020 23:30:29

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

    Great Idea...I'm using OBDC to connect but some times the update fail!

    Edgar Gerardo Chinchilla M's profile image Profile Picture

    719c81cd 2331-4d3c-b235-a53766cf6d17 on 05 Jul 2020 23:30:24

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

    Please add this feature!

    Edgar Gerardo Chinchilla M's profile image Profile Picture

    7d025dc7 4b41-47e9-90f3-c5edd077ca00 on 05 Jul 2020 23:29:04

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

    Why are Microsoft showing such poor support of their excellent Access database? Power BI couldn't even connect to the latest version (e.g. Office 365/Office 2016) without having to load the 2010 database engine distributable.

    Edgar Gerardo Chinchilla M's profile image Profile Picture

    7fd1c0fc bd66-4374-98c4-a1a43c499fc9 on 05 Jul 2020 23:26:56

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

    Without this feature it is going to take months to get my dataset. This improvement would speed up the time I can bring my manager valuable reports!

    Edgar Gerardo Chinchilla M's profile image Profile Picture

    ffbe43f0 9082-4d4e-a4c0-5803e7f90581 on 05 Jul 2020 23:26:20

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

    This is very critical to our business since the data inside our Access is sensitive (HR) and cannot be released with a valid user password.

    Edgar Gerardo Chinchilla M's profile image Profile Picture

    7f7caff6 92b1-48c1-8945-cdc604bc98b4 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

    822278aa 2c2b-41e1-a6a6-bb3e22486a64 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

    33f599d3 0592-4cca-89a3-02f85fff01ff 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

    174f4f56 1558-4e26-8fd5-b07dd0ed7513 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

    b960e5e2 2953-49b2-9fb6-93b4ec3df84c 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!!!!!