Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to 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.
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.
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.
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.
User | Count |
---|---|
102 | |
91 | |
87 | |
79 | |
71 |
User | Count |
---|---|
113 | |
105 | |
101 | |
75 | |
64 |