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
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

      • DanielaHo's avatar
        DanielaHo
        Frequent Visitor
        6 years ago

        I am not using people picker columns, no. I did go and populate all cells to ensure there are NO BLANKS but still it is not working...