Reply
keithfrb
New Member
Partially syndicated - Outbound

Multi Person Select Column

New to Power BI/Query.

 

How can I get this column to show the individual people?  This is from a SP List that is using multi select person.  I'd like to show Picture, FirstName, LastName, Department, JobTitle of the individuals assigned to this field.

 

column error.png

 

Thanks in advance!

1 ACCEPTED SOLUTION
keithfrb
New Member

Syndicated - Outbound

Had to revert back to the 'FieldValuesAsText' column and have the 'Requestee' checked which then displayed the users assigned to that field.

View solution in original post

6 REPLIES 6
keithfrb
New Member

Syndicated - Outbound

Had to revert back to the 'FieldValuesAsText' column and have the 'Requestee' checked which then displayed the users assigned to that field.

dufoq3
Super User
Super User

Syndicated - Outbound

Hi @keithfrb, are there any columns in your tables? Just click to white space beside any Table and provide a screenshot.


Note: Check this link to learn how to use my query.
Check this link if you don't know how to provide sample data.

Syndicated - Outbound

@dufoq3 

Interesting that this field is getting this error but not the others...


column error.png

Syndicated - Outbound

Try to google that error. I don't know how to help you with this issue.


Note: Check this link to learn how to use my query.
Check this link if you don't know how to provide sample data.

keithfrb
New Member

Syndicated - Outbound

@VillyMBI 

 

that was the first thing I tried.  there is nothing there.

column error.png

VillyMBI
Resolver I
Resolver I

Syndicated - Outbound

Hi @keithfrb ,

 

Try to click on VillyMBI_0-1710916060447.png  button of the data and you will able to expand the table information.

 

avatar user

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

Check out the March 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)