Forum Discussion
Fabric 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.
Thank you v-sgandrathi for your response. Can you explain what do you mean by this?
"As a possible solution, please verify that the original column in Dataverse is explicitly set to support decimal values."
I do see the value holding a decimal precesion on Dynamics front end. Where else can I check this?
Hi Gpop13,
Thank you for your follow-up.
To clarify, when we referenced verifying the original column in Dataverse for decimal support, we meant checking the actual data type at the schema level,rather than just depending on its appearance in Dynamics. Even if decimals are visible in Dynamics, the field may be set as a Whole Number or Floating Point Number, which can result in inconsistent precision when connecting to Fabric.
To confirm the data type, please navigate to Power Apps > Tables > select your table > Columns, and review the specific column to ensure it is defined as Decimal Number. This is recommended for maintaining precision during replication.
Thank you.
Thanks 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?
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.