Imported values have extra zeros

Hi Rapaille 

Thanks for the reply from Gabry, dilistimor, AntonioCarl and christinepayton .

Rapaille , I found a post for your reference, which has a similar problem as yours, and the problem is caused by the delimiter. One of the solutions is:

Solved: Wrong regional format in numbers from SharePoint l... - Microsoft Fabric Community

Or you can refer to this blog:

https://eriksvensen.wordpress.com/2018/07/02/powerquery-how-to-handle-different-decimal-separator-when-importing-csv-files/ 

Best Regards,
Yulia Xu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.