Running Python Script Changes Types and Adds Additional Zeros

[Babakhsn]

Hello everyone.

I am running a python script and I have realized that even when my script is empty, after running it the following problem occurs:

Power Query changes text types to decimal and this type changing results in an additional zero. 

This is the column before running the script:

This is it after running the script:

 In my applied steps, after running the script, there is a "Changed Type" step, when I remove it the numbers go to this:

 why is this happening?

can someone help me?

Thanks in advance.

Sincerely

[lbendlin · Accepted solution]

Seems to be a locale mismatch. Some cultures use a dot as the decimal separator while others use a comma.  Make sure your culture settings match between Power Query and Python.