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! 

 

 

  • Vicky_Song's avatar
    Vicky_Song
    Impactful Individual
    10 years ago

    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. 

    • ShaneC's avatar
      ShaneC
      Frequent Visitor
      10 years ago

      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's avatar
        vanghjort
        Regular Visitor
        10 years ago

        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's avatar
      radian21
      New Member
      10 years ago

      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's avatar
        amenne
        Frequent Visitor
        10 years ago

        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?

         

    • kmccool's avatar
      kmccool
      Regular Visitor
      8 years ago

      Vicky_Song Are there any updates on this issue?

      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]