Forum Discussion
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 zeros (2). What is going wrong?
Can someone help me with this?
Kind regards,
Hans
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.
10 Replies
Hello,
are you sure it is correctly reading the point as a thousand separator and not as decimal?
Hello Rapaille
Since it is a calculated column, I suggest you transform the column to the right type.
Click small icon on the left side of the column header
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.
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.
Thank you Anonymous, this is the solution for my issue.
