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