Forum Discussion

3sun_Jack's avatar
3sun_Jack
Regular Visitor
10 years ago
Solved

Connecting to a SharePoint List Office 365 error

Hi I am receiving the following error when I try and link a SharePoint site to Power BI   DataSource.Error: We couldn't parse OData response result.  Error: A null value was found for the property ...
Need Help
  • kompas_ua's avatar
    kompas_ua
    10 years ago


    I changed the ApiVersion from 15 to 14 in the Query Advanced Editor, and it works now =)

    let
        Source = SharePoint.Tables("https://###.sharepoint.com/teams/Team020/", [ApiVersion = 14]),
        ProjectList = Source{[Name="ProjectList"]}[Content]
    in
        ProjectList

djeepy1's avatar
djeepy1
Advocate I
10 years ago

rgparisoto

 

You have to use OData.Feed function instead of SharePoint.Tables to reach your list.

I guess this should be :

 

let
  origem = OData.Feed("https://XXXXX.sharepoint.com/gestao/_api/Web/Li​sts(guid'yyyyyy')/Items?$select=zzzzzzz")
in
  origem

where

  • XXXX is your Tenant
  • yyyyy is your list guid (the one you have in your second line - [Id="xxxxxx"])
  • ZZZZ is a comma-separated list of fields you want to get

 

Notice I added feedback to my previous comment. I do not know if it applies to your error / context.

 

Jean-Pierre Riehl

  • sAlexRUS's avatar
    sAlexRUS
    Regular Visitor
    10 years ago

    Tell me please
    Why does not this request?

     

    let

        soursOData = Data.Feed("https://<app web url>/_api/web/Lists(guid'DEE5D045-C8AB-4878-B3F1-0D814EBF648E')/Items?$select=TextMonth,TextQuarter")

    in 

      soursOData

     

    Error OData.Feed

    P/S/

    This code is working in the browser

  • rgparisoto's avatar
    rgparisoto
    Helper I
    10 years ago

    Thank you djeepy1! I'll try this model.

    Regards,

  • djeepy1's avatar
    djeepy1
    Advocate I
    10 years ago
    You get a HTTP 404 error on /$metadata resource of your list on your SharePoint.
    I'm not a SharePoint expert but maybe there's some specific setting on your list (or permission missing).