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

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

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).

  • kmccool's avatar
    kmccool
    Regular Visitor
    8 years ago

    Thanks for the help. I went into the SahrePoint list and added and N/A choice then did quick edit to update all empty values to N/A and it worked!

     

    Worth Noting:

    We completely removed the column in the Power BI query and still got the error. We removed all null in the query editor and got the error as well. Only thing that worked was editing the column in SharePoint.