Forum Discussion
Office 365 Access DB Connection Issues
Hi jlanglois ,
Can you open the file directly in Access Database? If you can't, this may be caused by the use of the ‘Large Number’ (BigInt) field data type. You could change the data type from Large Number to just Number. For more details, please see this article.
If there is no data type of ‘Large Number’ in your table, please check whether the vision of Power BI is 2.71.5523.821.
Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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.
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.