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

rgparisoto's avatar
rgparisoto
Helper I
10 years ago

Thank you djeepy1! I'll try this model.

Regards,