I am loading a fabric data warehouse using Dataflow Gen2 and have run into a weird problem. Whenever I do any floating point math with a couple of columns of the data I'm uploading, I get a good floating point result in dataflow but when it loads the data warehouse it rounds off the decmial portion of the number. I am loading it into a decimal(38) field in the database.
Here is an example of the transform statement and you can see the new column does have decimal data in it:
Helpful resources
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
