Forum Discussion

jlanglois's avatar
jlanglois
Regular Visitor
7 years ago

Office 365 Access DB Connection Issues

MS Access Version is : Office 365 2016 (16.0) 32-bit Power BI Version is: 2.71 32-bit   Error: Details: "Microsoft Access: The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local m...
Need Help
jlanglois's avatar
jlanglois
Regular Visitor
7 years ago

Thanks for the reply.

 

I checked my Access Database version and it is set to 16.7. I have around 60 tables, 5 of which are Access, the rest are Linked tables from a SQL Server. One of the Access tables had fields set as Large Number, I changed it to Number.

Unsure if any of hte SQL tables use Large number, I checked a few but not all. 

 

After changing the fields to Number, and installing the 2010 Database engine, is there anything else I need to do? 

Still get the version error on Power BI.

 

Yes that is the version of Power BI I am using.

 

Thanks.

 

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Are you connecting MS access DB as source or ODBC ? if ODBC try to create new ODBC by selection appropriate bit. i had this issue when i created with ODBC 32 bit then created in 64bit and used. it worked for me. also i used the MS access as source to avoid the ODBC issue.