connecting to Access database with a password，there is no window for entering the password.

[William_JINHUI]

将 Power BI 连接到 Access 数据库时，没有用于输入密码的弹出窗口。我还尝试了 ODBC 连接，但它一直显示驱动程序问题。我更新了与我的系统匹配的 64 位 ODBC 驱动程序，但它仍然不起作用。谁能帮我解决这个问题？或者提供其他方法的链接？目前，我从公共驱动器下载数据库文件，对其进行解密，然后使用 Power BI 创建可视化效果。但是，我需要将 Power BI 直接连接到公共驱动器上的 Access 数据库才能获取最新数据。

[v-tsaipranay]

Hi @William_JINHUI ,

We haven’t received an update from you in some time. Could you please let us know if the issue has been resolved?
If you still require support, please let us know, we are happy to assist you.

Thank you.

[v-tsaipranay]

Hi @William_JINHUI ,

I wanted to follow up on our previous suggestions. We would like to hear back from you to ensure we can assist you further.

Thank you.

[v-tsaipranay]

Hi @William_JINHUI ,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.

Thank you.

[v-tsaipranay]

Hi @William_JINHUI ,

Thank you for reaching out to the Microsoft fabric community forum.

Currently, the native Access connector in Power BI does not support password-protected Access databases and does not prompt for credentials. As correctly mentioned by @Cookistador , the recommended workaround is to use the ODBC connector with a properly formatted connection string and then enter Admin as the username along with your database password when prompted. This method is fully supported and should allow you to connect successfully.

I hope this helps, if you need any further assistance, feel free to reach out.

Thankyou.

[Cookistador · Accepted solution]

 Hi @William_JINHUI 

Instead of using MS Access connector use ODBC connector like this:

Just pass the connection string with the follwowing structure:

Driver={Microsoft Access Driver (*.mdb, *.accdb)};Dbq=YourPath\YourDB.Filetype

Then on the following page, use Admin and your password to connect