Don't miss your chance to take the Fabric Data Engineer (DP-700) exam on us!
Learn moreWe've captured the moments from FabCon & SQLCon that everyone is talking about, and we are bringing them to the community, live and on-demand. Starts on April 14th. Register now
I get this error message whenever I try to connect to an Access database (PowerBI.accdb for example), but I can connect to Excel spreadsheets just fine.
Details: "Microsoft Access: The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine. The 64-bit version of the Access Database Engine 2010 Access Database Engine OLEDB provider is required to connect to read this type of file. To download the client software, visit the following site: https://go.microsoft.com/fwlink/?LinkID=285987."
I don't know what this error message means. I followed the link shown and installed the latest version of Power BI Desktop as it instructed. I have 64-bit Office and Power BI Desktop, but I'm still getting this same error message. Please help.
Solved! Go to Solution.
Hi
I guess you need to download the Microsoft Access Database Engine driver. You can download it here: https://www.microsoft.com/en-us/download/details.aspx?id=13255
Hope this helps
JJ
Hi
I guess you need to download the Microsoft Access Database Engine driver. You can download it here: https://www.microsoft.com/en-us/download/details.aspx?id=13255
Hope this helps
JJ
That totally did the trick for me.
Thank you so much JJ!
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
| User | Count |
|---|---|
| 53 | |
| 37 | |
| 35 | |
| 19 | |
| 17 |
| User | Count |
|---|---|
| 74 | |
| 72 | |
| 39 | |
| 35 | |
| 23 |