I keep getting the same error everytime I try opening the Access database on Power BI. I'd really appreciate if someone could please help me out.
Below is the exat error:
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 had the same problem, and it was caused because I had the MS Office x32 bits installed, and the PowerBI desktop in x64. All you have to do is to install the PowerBi version (x32 or x64) according to your Office.