cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
szlipcsei
Frequent Visitor

Person or Group based names appearing on PowerBI

Hi there,

 

When I link a sharepoint list to PowerBI and try to use the "Person or Group" based name columns, the names will not appear, but numbers. And I can't really work with numbers at all when I need to filter for names etc.

 

This is how it looks on PowerBI:

Person or Group ID.JPG

 

This is how it looks on the connected SP:

 

SP Column.JPG

 

Thanks, Szilárd

1 ACCEPTED SOLUTION
v-qiuyu-msft
Community Support
Community Support

Hi @szlipcsei,

 

Person and group type columns in SharePoint list are lookup columns which fields lookup into another SharePoint list, so you will get the value expressed as "Record" in Query Editor. You can follow Vicky_Song's suggestions in this thread: How to display an assigned user in a sharepoint list in Power BI (o365)?.

 

Best Regards,
Qiuyun Yu

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

5 REPLIES 5
hemal_kanjia
Helper I
Helper I

Can anyone give the solution step by step ?

I am also facing the same issue.

 

Thanks in advance....

Sure. When you are on the Edit Query, go to the column called Field value as text.

 

FVAT.JPG

 

Select the columns what you want to have as text.

 

Select column.JPGyou want to have as text only (so not the numbers)

this way worked for me, thank you!

v-qiuyu-msft
Community Support
Community Support

Hi @szlipcsei,

 

Person and group type columns in SharePoint list are lookup columns which fields lookup into another SharePoint list, so you will get the value expressed as "Record" in Query Editor. You can follow Vicky_Song's suggestions in this thread: How to display an assigned user in a sharepoint list in Power BI (o365)?.

 

Best Regards,
Qiuyun Yu

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

The post doesn't make sense. Where's an actual solution? When you follow those instructions, you still get nothing but numeric IDs instead of the names that you want. 

Helpful resources

Announcements
Power BI October Update 2021.jpg

Power BI Release

Click here to read more about the October 2021 Release!

Microsoft Ignite 768x460.png

Find your focus

Explore the latest tools,training sessions,technical expertise, networking and more.

Power BI Womens Summit 2021 768 x460.jpg

Interviews, learning sessions, allies, and more!

#PowerBIWomenSummit

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!