Get persons name from Sharepoint multiselect person column

[guyatisk]

How can I get the name(s) from a field in SharePoint for Power BI?  I see that the problem with this being a Table instead of a record is due to the fact that in SharePoint, this can contain more than one person, understandably.  How do I get this data and represent it into a report where I can slice data on these results?  Thanks for the information.

[v-tangjie-msft · Accepted solution]

Hi @guyatisk ,

In the Power Query editor, locate the column with the Multiple Choice Person field. Click the expand icon (two arrows) on the column header to expand the field. If the name is in a nested table within the expanded column, you will also need to expand those tables.

You can refer to the similar posts that may be helpful to you: 

Using Power BI to Report on Person Fields in SharePoint – The White Pages (bifocal.show)

Sharepoint person column with no fields? - Microsoft Fabric Community

 How to retrieve "correct" column names from ShareP... - Microsoft Fabric Community

SharePoint Online List column with multiple person... - Microsoft Fabric Community

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly.