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.
5 Replies
- FapoFrequent 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
- mttwssFrequent Visitor
There is no username...only password.
- AnonymousNot applicable
Thank so much.
This's so helpful.
- AnonymousNot applicable
Hi Bucksy,
Password-protected Access database files are still not supported. I am afraid that the feature is not in the pipeline, if Power BI team has plan to add this feature, some feedback will be sent in this idea: https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/10517454-add-connection-to-password-protected-mdb-accdb-mic .
Thanks,
Lydia Zhang - mohanreddykNew Member
Hi Team,
Can you please share the information regarding the above query.
Thanks,
Mohan