Forum Discussion

AbelNewton's avatar
AbelNewton
Frequent Visitor
10 years ago

Error in opening an accdb file

My PowerBi version:2.34.4372.501 32-bit (April 2016) Microsoft Access version:2016 32 bit  when opening an accdb file, there arises a problem: Unable to connect  Details: "Microsoft Access: The 'M...
Need Help
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
10 years ago

I think the problem is that you can't open the Access database... :)

 

Seriously though, I imagine that the problem is that Power BI is looking for an older version of the Access database drivers. Check out this thread here:

 

https://social.msdn.microsoft.com/Forums/en-US/1d5c04c7-157f-4955-a14b-41d912d50a64/how-to-fix-error-the-microsoftaceoledb120-provider-is-not-registered-on-the-local-machine?forum=vstsdb

 

I believe that the driver it is looking for was made for 2007 Office.