Power Query SharePoint List Error with Allow Multiple Selection on People or Group Field

[stvcdms]

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 error. Changing the field to disable allow multiple selection resolves the issue. Has anyone else noticed this or know a way around this?

Steve

[umamahesh2u]

I am still facing this issue. Any resolution/workaround we have for thi issue?

[umamahesh2u]

Is there any fix available for this?

[julianmbs]

I was getting a similar error:

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.String)[Nullable=False]'. The expected type 'Collection(Edm.String)[Nullable=False]' does not allow null values.

I have "Assigned To" column in my list, and I changed it to not allow multiple selections. So now I am getting this error:

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

I don't even have "Previously Assigned To" column in my list, so where is it coming from?

If I change the API version from 15 to 14, I get an error as the poster above:

Expression.Error: The key didn't match any rows in the table.
Details:
    Key=Record
    Table=Table

Is there some kind of work-around for this issue?

[HSLoh]

---

@julianmbs wrote:

I was getting a similar error:

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.String)[Nullable=False]'. The expected type 'Collection(Edm.String)[Nullable=False]' does not allow null values.

I have "Assigned To" column in my list, and I changed it to not allow multiple selections. So now I am getting this error:

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

I don't even have "Previously Assigned To" column in my list, so where is it coming from?

If I change the API version from 15 to 14, I get an error as the poster above:

Expression.Error: The key didn't match any rows in the table.
Details:
    Key=Record
    Table=Table

Is there some kind of work-around for this issue?

---

I am having the same issue as him...please advise....thanks.....:)

[julianmbs]

I got an advice from a colleague that dealt with the same problem: Connect to the Sharepoint List as OData Feed instead.

I have tried it before like this: https://companyname.sharepoint.com/sites/Home/Analytics, but was getting an error "User not authorized". So he had me try this: https://companyname.sharepoint.com/sites/Home/Analytics/_vti_bin/listdata.svc and it worked!!

[Vicky_Song]

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]

Hey Vicky, 

Was there ever a fix for this scenario? 

I'm encountering this situation also.

Thanks!

Evan

evan.haag2@toyota.com

[Vicky_Song]

@stvcdms, It is identified as a known issue with SharePoint that the team is actively working to resolve. Will keep you updated once I get any updates. 

[kmccool]

@Vicky_Song Are there any updates on this issue?

Thanks

[ShaneC]

Any further updates to this? It is a pretty common scenario and the fact that Microsoft is supporting the ability to allow Power BI to connect to a SharePoint Online list as a supported datasource, and it fails, is pretty crazy!

Out of the box it fails and you have to set the API version from 15 to 14 to to get something working.

Please help with this!

[vanghjort]

If I change the API version from 15 to 14, I still get an error:

Expression.Error: The key didn't match any rows in the table.
Details:
    Key=Record
    Table=Table

Do some of you have a way to remove this error?

Thx in advance

[radian21]

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?

[amenne]

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?