Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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.
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.
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.