Forum Discussion
Pipeline Data Copy Decimal type values are changed
Looks like a (double) floating point to string conversion issue. I get the same when I use a Copy Data activity to output some decimals. Might well be worth raising as a support ticket in Fabric. As a work around, use the decimal data type instead.
If when you have your decimal data stored in the table as the decimal type, you get the following.
Floats are marginally worse;
Another alternative would be to do the conversion in a Notebook.
If you found this answer helpful, please marks as a Solution to help others find it.
Looks like a (double) floating point to string conversion issue. I get the same when I use a Copy Data activity to output some decimals. Might well be worth raising as a support ticket in Fabric. As a work around, use the decimal data type instead.
If when you have your decimal data stored in the table as the decimal type, you get the following.
Floats are marginally worse;
Another alternative would be to do the conversion in a Notebook.
If you found this answer helpful, please marks as a Solution to help others find it.