Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join us at FabCon Vienna from September 15-18, 2025, for the ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM. Get registered

Reply
nutpapon_lim
Regular Visitor

Pipeline Data Copy Decimal type values are changed

Hi,

 

I'm trying a simple experiment. I want to copy data from Tables in Lake house to csv Files in the same Lake house.

However, I found that the value of decimal data in Table is changed when it was written into File.

For example, if I have value 0.045 in Table, it will be 0.044999999999999998 in File instead. I just want to write 0.045.

The problem only happens on 3 decimal place values. I have tried to change the file type but it has not helped. 

I have attached the example. Please feedback me how to correct this. 

 

Thank you,

Nutpapon Lim

 

01.png02.png

1 ACCEPTED SOLUTION
spencer_sa
Super User
Super User

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.

spencer_sa_0-1733357773667.png

If when you have your decimal data stored in the table as the decimal type, you get the following.

spencer_sa_1-1733358435840.png

Floats are marginally worse;

spencer_sa_2-1733359191053.png

 

 

 

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.

View solution in original post

1 REPLY 1
spencer_sa
Super User
Super User

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.

spencer_sa_0-1733357773667.png

If when you have your decimal data stored in the table as the decimal type, you get the following.

spencer_sa_1-1733358435840.png

Floats are marginally worse;

spencer_sa_2-1733359191053.png

 

 

 

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.

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June FBC25 Carousel

Fabric Monthly Update - June 2025

Check out the June 2025 Fabric update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.