SharePoint Online List column with multiple person values

[Sebastian0406]

Dear community,

I have two questions for you and I hope you can help me.

1. how can I get both names to be displayed in my table if there are two IDs in one column in my sharepoint list?

When I click in the column under "Transform data", not just one ID appears, but several, i.e. three names should be displayed, separated by a semicolon.

There should actually be three names below "Title" in 2015-601, but there is nothing.

2. Is it possible to have two relationships between two identical sharepoint lists activated at the same time? I always get the error message "There are ambiguous paths"

I would like to access another ID on the same table as you can see above in order to display a new column with a different function, which of course has a different name than the first column in "Title".

Thank you very much in advance!!

BR

Sebastian

[christinepayton · Accepted solution]

I have a tutorial that covers multivalue person fields in Power BI here: https://youtu.be/LYu3wqb2Nx4?si=HrcP36O1IsyCpjVS&t=527 

You can relate data from the list, and that's what I do there - you just relate on the ID field between the two. You can't have more than one relationship active with the same two tables at the same time, but you can have multiple dimensions related to the items table. The relationships for SharePoint data follow the same rules as all the other data sources, so the modeling strategy will be similar to any other data source.