Forum Discussion

mikemohr1's avatar
mikemohr1
New Member
9 years ago

MS Access Data Format Error

Hi The MS Power BI tool was working well when I had it linked to my MS Access 2016 Office 365 software. But since the July update (and now even when i revert back to June update) as soon as I refresh...
v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
9 years ago

Hi mikemohr1,

 

After research, this issue might occur if you try to open a database that contains a table that uses the BigInt data type. To resolve this issue, determine whether the use of BigInt is required. If so, update users to Access 2016 version 16.0.7xxx.xxxx or later. Alternatively, change the data type from Large Number to just Number. For more details, please see this article.

 

By the way, can you directly open the db file in MS Access?

 

Regards,
Yuliana Gu