Forum Discussion

kastorsky's avatar
kastorsky
Regular Visitor
9 years ago
Solved

Getting wrong data from a Sharepoint list (calculated field)

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...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    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.

jorge_garcia's avatar
jorge_garcia
Advocate I
6 years ago

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.