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

  • mikemohr1's avatar
    mikemohr1
    New Member
    9 years ago

    Hi Thanks for the idea, but I'm the only user in this test environment. I made and use the underlying MS Access database all the time and works perfectly, no issues. The Power BI was working up until the June update and when the MS Store helped me put the May update back on, we still have the issue. I do not have any BigInt number format that I know of, just normal Double or Long Interger format.

     

    Other idea?

    THanks

    Mike

    • mikemohr1's avatar
      mikemohr1
      New Member
      9 years ago

      HI now I understand so I checked all the many tables I have in the database, all the fields with numbers are in Data Type: Number...every one of them

      Other idea?

      Thanks

      • v-yulgu-msft's avatar
        v-yulgu-msft
        Microsoft Employee
        9 years ago

        Hi mikemohr1,

         

        So, you can directly open the accdb file in MS Access 2016 Office 365, right? To determine, whether the problem is caused by accdb file or by Power BI desktop, would you please try to connect to this db file in Power Pivot? Also, please recreate a new db file with some simple data, then, connect to this new file in desktop to see whether error perists?

         

        Regards,
        Yuliana Gu