Getting wrong data from a Sharepoint list (calculated field)

[kastorsky]

Hi everyone, I'm getting a strange situation with PB Desktop. I hope someone could give me an advice.

I'm trying to get data from a sharepoint list that has a calculated field (sum of two numbers) but when the PB get the value from this field it return with 14 zeros more, something like "xE+14"

Maybe I'm forgetting something... follow the example.

[jorge_garcia]

Hi fcarvalho,

I´ve been facing the same wrong number format, but getting data from Sharepoint online List.

Im the source line for sharepoint on-line, Power BI Desktop just give me the command = SharePoint.Tables("https://3albecombr.sharepoint.com/sites/Representantes", [ApiVersion = 15]).

I´m not able to replace by OData.Feed as suggested.

Thanks in advace for any thoughs.

[Anonymous]

Hi @kastorsky,

Maybe because of your regional settings. In sharepoint you use dots or comma to decimal numbers? If not try to use ROUND in your formula.

[kastorsky]

I thought it was that but I'm using integer not decimal number... So I've already changed my PB to use dots as my sharepoint and also I've tryed the ROUND but nothing happens. The PB receive the value as thousands.

[Anonymous · Accepted solution]

I can reproduce your issue in my side with portuguese regional settings.

Change your source to:

= OData.Feed("https://NAME.sharepoint.com/sites/NAME/_vti_bin/listdata.svc")

change only your link, you need the: 

/_vti_bin/listdata.svc

Using OData.Feed you will get what you want.