Forum Discussion
Connecting to a SharePoint List Office 365 error
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
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.
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
If this field is not always set, put an entry "none" and choose it by default.
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.
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.
