Values are not seen after comma

Question

Hello, in my original excel file I have two columns with decimal numbers, but in power bi only the numbers that are before the comma are displayed, and all those that are after are seen as zeros. How can this be fixed?

In the excel they appear as follows:

in power bi all records are listed as -58.0000000 or -34.00000

amitchandak · Answer

Syndicate_Admin , Open power query, and check, it should ve decimal or text there. Seem like it got converted to a whole number there

syndicate_admin · Answer

Hello! Thanks for your reply! Sorry, open query of what? What kind of number should be configured?

syndicate_admin · Answer

Yes, it is in decimal format and as latitude/longitude, but still, it does not bring the values after the comma.

amitchandak · Answer

Syndicate_Admin , I can see both of these columns do not have value after the decimal place in the power query. Go to the steps of power query and check, the first step where these columns are visible. do they data after the decimal place. if yes, check and change the step where it got removed. 
&nbsp;
if they do not have decimal data even on the first visible (data is visible) then you should check it adding the file again