Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello,
I am trying to connect Power BI to a password-protected MS Access File.
When I try and get the data by clicking "get data" in Power BI, select the MS Access file, it results in this:
I need the MS Database to be password protected, as all data contains confidential information.
Thank you.
I've tried your solution, but I entered the wrong username and password then error, when I try to enter the correct username and password, the menu doesnt show up, only error like this
help me to solve it pleasee..
Hi,
Instead of using MS Access connector use ODBC connector like this:
Driver:
Driver={Microsoft Access Driver (*.mdb, *.accdb)};Dbq=YourPath\YourDB.Filetype
In the pop up enter Admin and password:
I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!
My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/
Proud to be a Super User!