Forum Discussion
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:
Best Regards,
Yulia XuIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
This is normal for SharePoint. SharePoint lets you choose to display it as a whole number in the list, but it doesn't physically change the data type in the list on the back end between decimal and whole number - it just shows it to the user differently depending on the setting. On the Power BI side, you can set the type in the toolbar in Power Query to whole number if you want it to be one there.
Data type en format in Power BI is already whole number. Power BI shows also a whole number but while 3643 is the number in the SharePoint list, Power BI shows 364300000000000.