Forum Discussion
mikemohr1
9 years agoNew Member
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
9 years agoNew Member
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
9 years agoMicrosoft Employee
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