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

Hi!
is there any news on this topic?

 

I read in other post the possible temporary workaround, filling null values or disableallowing multiple selection.

 

thanks.

best regards.

 

 

DanielaHo's avatar
DanielaHo
Frequent Visitor
6 years ago

Hello - I am still facing this issue.. any fix yet? 

 

Changing API to 14 resolves the prolem BUT as a result the multi-select columns only return the first value, not all of them. So that's not a very useful 'fix'... :(

  • karo's avatar
    karo
    Advocate V
    6 years ago

    Hi DanielaHo Unfortunately nothing  new what I am aware of - except of changing Sharepoint List configuration :(

    • DanielaHo's avatar
      DanielaHo
      Frequent Visitor
      6 years ago

      Well the strange thing is that I have a different list with exactly the same column - multi-select choice - and Power BI is handling it perfectly fine!? So it does not seem to be an issue across the board.

      • karo's avatar
        karo
        Advocate V
        6 years ago

        Hi DanielaHo , Just only out of my curiosity, does your list contains Nulls?

        In my case conenction Multiple Selection on People or Group Field with Nulls are the issue :(

         

        Regards,

        Karo