Why are my numbers showing as decimal in power query but whole number in table view?

[dgilm33]

I have a value that I'm wanting to show as a decimal number. In power query I have the data type as a decimal number and it shows correctly. I apply and close, and after it finishes loading, the value shows as the nearest whole number, even when the data type is decimal number with 2 decimal spots showing.

[negi007]

@dgilm33 powerbi desktop can change the format during data loading. you can fix the format

[dgilm33 · Accepted solution]

I was using decimal number as both the data type and format, but it was still showing incorrect. I was able to fix this by using fixed decimal number as the data type before loading instead of decimal number.