Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Hi Team,
Can you please share the information regarding the above query.
Thanks,
Mohan
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-passwo... .
Thanks,
Lydia Zhang
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
95 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |