Forum Discussion
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 ...
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.
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
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...