How I can show the user-names for a People or Group site column which allow multiple selection insid

[PowerBi1234]

I have a SharePoint online list which contain 2 site columns:-

1. People or Group site column which allow multiple selection
2. People or Group site column which allow single selection

and i am showing the above SharePoint list inside PowerBI. where i got the following:-

1. For the "People or Group site column which allow multiple selection" >> i got a list instead of the actual usernames
2. For the "People or Group site column which allow single selection" >> i got the user id instead of the actual username

for point-2 i join the list with the User Information list and i am able to show the username instead of the user ID. but for point-1 i am not sure how i can convert the List into usernames? is this supported?

[lbendlin]

Same thing, split the ID list and then link each individual ID to the User Information List.

[PowerBi1234]

@lbendlin  so how i can split the list?

[lbendlin]

Select the column, split by delimiter, split into rows.

[PowerBi1234]

@lbendlin  ok i did this where the column was splitted into 2 columns, but what if i have more users in another list item? then i need to re-split the people or group field again?

[lbendlin · Accepted solution]

split into rows, not columns.