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

kleinbth's avatar
kleinbth
Frequent Visitor
10 years ago

This error message will been given when a multiple user or multi choice field is empty. When all the fields are filled this error message will not been given

Anders99's avatar
Anders99
Regular Visitor
10 years ago

Any news on when this bug will be fixed? To be clear it affects both the Power BI desktop client as well as Excel (Power query).