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

Anders99's avatar
Anders99
Regular Visitor
10 years ago

This error also exists in newer versions of Power Query, we tracked it down to an error in the Query code that Power BI and the newer versions of Power Query use to query the oData feed. Quite a serious bug that needs resolving.

 

Update: A clarification this error will appear if you have any multichoice fields.

kleinbth's avatar
kleinbth
Frequent Visitor
10 years ago

This error message is also been given by a multiuser field

  • kleinbth's avatar
    kleinbth
    Frequent Visitor
    10 years ago

    Even when I try to remove the fields in advanced mode it will give the error message.

    • kompas_ua's avatar
      kompas_ua
      Advocate I
      10 years ago

      So, as I understood, now there is no any workarounds?

      • kompas_ua's avatar
        kompas_ua
        Advocate I
        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