Forum Discussion

Babakhsn's avatar
Babakhsn
Helper I
2 years ago
Solved

Running Python Script Changes Types and Adds Additional Zeros

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

  • 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.

1 Reply

Replies have been turned off for this discussion
  • 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.