- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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.

Helpful resources
Power BI Monthly Update - July 2025
Check out the July 2025 Power BI update to learn about new features.

Subject | Author | Posted | |
---|---|---|---|
04-22-2025 01:13 PM | |||
Anonymous
| 11-29-2021 02:16 AM | ||
Anonymous
| 06-02-2022 11:30 PM | ||
03-24-2025 03:56 AM | |||
03-20-2025 07:59 AM |