Forum Discussion

mcraine15's avatar
mcraine15
Regular Visitor
8 years ago

Trouble with MS Access Large Number Format

Hi, I'm having trouble accessing a relatively large dataset (~1.5GB) stored in Microsoft Access 2016 with several fields (~30) formatted as Large Numbers. The error message I receive when attempting...
Need Help
v-xjiin-msft's avatar
v-xjiin-msft
Solution Sage
8 years ago

mcraine15

 

I can repro your issue as creating a MS Access table which is containing a large number field. When use it as a data source in Power BI. I got the same error. And my environment is same as yours.

 

It seems like this is a limitation for Access Database.

 

Thanks,
Xi Jin.