Forum Discussion

Bucksy's avatar
Bucksy
New Member
9 years ago

How do I connect to a password protected Access Database? Is this in the pipeline?

I am trying to connect to an Access Database that is password protected. No go: I have already put in a request for this (last year) and wonder if it is in the features pipeline.

5 Replies

  • Fapo's avatar
    Fapo
    Frequent Visitor

    Actually, you can. Just follow these steps:

    - Go to Search (on the taskbar) and search for 'ODBC'

    - Create a new ODBC Access data source linked to that particular .mdb file

    - Go to Power BI, "Get Data", and select ODBC

    - Select the ODBC data source you created, and a screen will prompt, asking for the password

    - Enter the username and password of the database, and you are done

    • mttwss's avatar
      mttwss
      Frequent Visitor

      There is no username...only password.

    • Anonymous's avatar
      Anonymous
      Not applicable

      Thank so much.
      This's so helpful.

  • Hi Team,

     

    Can you please share the information regarding the above query.

     

    Thanks,

    Mohan