Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin 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
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
Solved! Go to Solution.
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.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Fabric update to learn about new features.