Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
kastorsky
Regular Visitor

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) 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.

 

PB.pngsharepoint.png

1 ACCEPTED SOLUTION
Anonymous
Not applicable

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.

View solution in original post

4 REPLIES 4
jorge_garcia
Advocate I
Advocate I

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
Not applicable

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.

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
Not applicable

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.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.