Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 to access the database is "The database you are trying to open requires a newer version of Microsoft Access." I do not receive this message with databases that do not contain Large Number formatted fields.
I'm running the latest versions of Power BI (January update), MS Access (version 16.0.8xxx) and MS Access database engine 2016. All of this runs at 32 bit.
Can anyone provide a workaround or solution to avoid this error message? Solutions I've tried include:
Thanks in advance for the help!
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.
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 to access the database is "The database you are trying to open requires a newer version of Microsoft Access." I do not receive this message with databases that do not contain Large Number formatted fields.
I'm running the latest versions of Power BI (January update), MS Access (version 16.0.8xxx) and MS Access database engine 2016. All of this runs at 32 bit.
Can anyone provide a workaround or solution to avoid this error message? Solutions I've tried include:
Thanks in advance for the help!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
117 | |
104 | |
77 | |
73 | |
52 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |