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.
Is there a particular syntax I need to use to open a password protected database? The interface is returning 'not a valid password' rather than a password prompt, so i tried amending the query string for the source in the advanced editor to:
let
Source = Access.Database(File.Contents("R:\Databases\Membership.accdb","PWD=xxxxxxx"))
in
Source
This was just a guess really on finding a similar syntax on an unrelated technet page. however it then returns 'expected 1 argument and found 2'. Attempting to add /PWD as a switch in the single argument is viewed as an additional file/directory.
Solved! Go to Solution.
Password-protected Access database files are currently not supported. Please add a vote for this in our Feature Suggestions forum if you find it's important: https://support.powerbi.com/forums/265200-power-bi
Regards,
M.
Does anyone know if Password-protected Access database files are supported now? I also get "not a valid password"
Friend, I suffered... Use an OLE DB connection like this:
provider=Microsoft.ACE.OLEDB.12.0;data source=C:\PathToYourDatabase\DBAccessNameHere.accdb;jet oledb:database password=yourpasswordhere
It works! Believe me.
If you are using this in excel, you'll want to make sure the connection string is using the proper case for the parameters and that you include the ";" at the end of the connection string. You'll also want to include a SELECT statement. If your access db has table that use hypens, then you will need to change the access tables names to use underscores instead, otherwise an error will be thrown. See article for description of solution.
https://superuser.com/questions/1309052/how-to-import-password-protected-ms-access-tables-to-excel
Password-protected Access database files are currently not supported. Please add a vote for this in our Feature Suggestions forum if you find it's important: https://support.powerbi.com/forums/265200-power-bi
Regards,
M.
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 |
---|---|
110 | |
97 | |
78 | |
64 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |