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...
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

  • mikemohr1's avatar
    mikemohr1
    New Member
    9 years ago

    HI

    Thank you again for your kind help. Yes I can use the MS Access 2016 Office 365 no problem. If I make a new generic table in my database, Power BI will not link to it but gives me the message that MS Access is outdated (which was not the case in May Power BI release). If I make a new Power BI file and try to connect back to the MS Access, it doesn't work - same Error Message.

     

    But if I make a new MS Access database using the same MS Access 2016 Office 365 and add a test table, Power BI links to it just fine. If I copy my original query in the MS Access 2016 Office 365 and using it as a Make Table query, save it to a new blank MS Access 2016, then reference the same same Power BI file, all works fine. 

     

    So it does look like my real database does have an issue sine the June Power Bi update even though I use MS Access 2016 Office 365 to open and work with it just fine. I just don't know why or what the problem is becuase now my solution is to change all my database queries to which Power BI is built off of to Make Table queries that copy to a new dummy database, the change the reference of all my Power BI charts etc, all works well.

     

    Just a huge hassel and a short term solution for the moment. Any thoughts to this helps for sure.

    Thank you for your kind thoughts in advance

    Mike

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

      Hi mikemohr1,

       

      In the original pbix file which prompts error when attempting to open it, did someone make any change to the data source query?

       

      Regards,
      Yuliana Gu

      • mikemohr1's avatar
        mikemohr1
        New Member
        9 years ago

        Hi

        No it is just me on my MS Surface Pro3 and the software. And I tried a new Power BI file linking to the database as a fresh start and I still get the same message that the MS Access version is outdated. But if I start a new Power BI file and link to a new MS Acess database it works...same version and everything.

        Thanks

        Mike