Dataverse linked tables: incorrect values in Currency fields (bug?)

Copper Contributor

Access tables linked from Dataverse show incorrect values in Currency fields starting from the 301st record if opened in the Access interface (for example, a value of 759,8114 € becomes 75981140000000005). If opened from the Dataverse Tables PowerApps web interface, the values are correct. To reproduce the bug, create a table, in Access or Excel, with a Currency field (for example, ID and UnitPrice - in Excel generate random numbers with 4 decimals for the UnitPrice field and format it as Currency). Test1: export the Access table in Dataverse from Access using the correspondent Access functionality and choose to relink the exported table in Access. Open the linked table in Access and verify that starting from the 301st the values are incorrect. Test2: import the Excel file in Dataverse via the PowerApps website interface. Change the data type in Currency in the Power query web interface. Link the Dataverse table in Access and verify that starting from the 301st the values are incorrect.

0 Replies