Forum Discussion
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.
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
There is no username...only password.
Thank so much.
This's so helpful.
