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

Rémi's avatar
Rémi
Icon for Resolver III rankResolver III
10 years ago

Hi,

 

Check that all lines have a value into this column.

Although, you can try to delete the "not null" property of the field (I don't know if it's possible, but it might solve your problem)

 

Then I advice you to put a default value into this field, otherwise the issue may appear again.

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

    thats the problem that not all entries require this field to have a entry, i agree that if they were all populated this wouldn't be an issue. but i can not find any where where it stipulates that this field is required, it certainly isn't set in SharePoint

    • Rémi's avatar
      Rémi
      Icon for Resolver III rankResolver III
      10 years ago

      If this field is not always set, put an entry "none" and choose it by default.

      • ssinchak's avatar
        ssinchak
        New Member
        10 years ago

        I am having the same issue wth a task list with the assigned to field.  There is no option to set a default value for this one.  

         

        DataSource.Error: We couldn't parse OData response result. Error: A null value was found for the property named 'AssignedToId', which has the expected type 'Collection(Edm.Int32)[Nullable=False]'. The expected type 'Collection(Edm.Int32)[Nullable=False]' does not allow null values.