Forum Discussion
Advocate IVFabric link from Dataverse - decimals lost on column value
Hi Gpop13,
Thank you for confirming that the column is of type Currency in Power Apps.
While the Currency data type in Dataverse does support decimal precision, we’ve observed that during the "Link to Fabric" process, these fields may sometimes be mapped in a way that causes the decimal portion to be lost in the Lakehouse table. This is because Currency fields in Dataverse are stored with additional metadata (such as currency codes), and in some cases, the value field may be interpreted as a whole number during replication.
At this time, this appears to be a limitation in how Currency fields are handled during automatic schema generation when linking Dataverse to Fabric. To retain decimal precision, we recommend considering Dataflow Gen2 as an alternative ingestion method, where you have more control over data type mapping and transformation.
Regards,
Sahasra.
Advocate IVThanks v-sgandrathi . I checked and the datatype that shows on Power Apps table for that column is currency. So does it not support decimals in Fabric link?
Community SupportHi Gpop13,
Thank you for confirming that the column is of type Currency in Power Apps.
While the Currency data type in Dataverse does support decimal precision, we’ve observed that during the "Link to Fabric" process, these fields may sometimes be mapped in a way that causes the decimal portion to be lost in the Lakehouse table. This is because Currency fields in Dataverse are stored with additional metadata (such as currency codes), and in some cases, the value field may be interpreted as a whole number during replication.
At this time, this appears to be a limitation in how Currency fields are handled during automatic schema generation when linking Dataverse to Fabric. To retain decimal precision, we recommend considering Dataflow Gen2 as an alternative ingestion method, where you have more control over data type mapping and transformation.
Regards,
Sahasra.