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
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!