Forum Discussion

Helper I

1 year ago

Solved

Imported values have extra zeros

Hello, I have a sharepoint list with a calculated column. The calculation works fine and the value shows well in the SharePoint list (1). After importing the data in Power BI the value gets extra...

Need Help

Anonymous
1 year ago
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.

Anonymous

Not applicable

1 year ago

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.