Forum Discussion
Power Query SharePoint List Error with Allow Multiple Selection on People or Group Field
Hello, I noticed today that if I am trying to connect to a SharePoint list and that list has a People or Group field with the allow multiple selection option enabled, that it causes a null value ...
Hi. I'm encountering the same error trying to connect Power BI to a SharePoint list that contains multi-select choice fields. I recall having a similar problem connecting Excel to the same SP list via the SharePoitn OData REST service. Excel could not parse the XML node containing the multi-select values. Likely something similar happening here.
Any updates?
I am having the same issue!
DataSource.Error: We couldn't parse OData response result. Error: A null value was found for the property named 'Flip', which has the expected type 'Collection(Edm.String)[Nullable=False]'. The expected type 'Collection(Edm.String)[Nullable=False]' does not allow null values
Where are we with a fix on this?