Why data loaded in power bi is zero

[peoplehelpme]

From excel i have data like this

but when i loaded to power bi ,i got this

Please help me, I am very thank you

[Nandha_Kumar_SR]

Its because power BI removes the zeros which are in the end after the decimal point when the FORMAT is GENERAL and the DATATYPE is DECIMAL NUMBER. You can change the No. of decimal places for all values in column tools.

[JoeBarry]

Hi @peoplehelpme 

Try transforming the column to Number in Power Query, this will provide a decimal number

thanks

Joe

If this post helps, then please Accept it as the solution