Forum Discussion

stvcdms's avatar
stvcdms
Frequent Visitor
10 years ago

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 ...
Need Help
Vicky_Song's avatar
Vicky_Song
Impactful Individual
10 years ago

Hi Steve, 

 

Yes, I can reproduce your issue. When I set the Person or Group column to be "Allow multiple selections", and at the same time has null value in the column, I get the error message: "DataSource.Error: We couldn't parse OData response result. Error: A null value was found for the property named 'omqwId', which has the expected type 'Collection(Edm.Int32)[Nullable=False]'. The expected type 'Collection(Edm.Int32)[Nullable=False]' does not allow null values." when connect to the SharePoint list in Power BI.

 

I need to either fill these null values, or disable allow multiple selections as you figured out. 

 

I will report this issue internally, and will post back once I get any updates. Thanks! 

 

 

ehaag0419's avatar
ehaag0419
New Member
9 years ago

Hey Vicky, 

 

Was there ever a fix for this scenario? 

 

I'm encountering this situation also.

 

Thanks!

 

Evan

[email protected]