Description user name

[Giorgio67]

Good morning;

my report get data from sharepoint list. Into list I read the user's name but with report PowerBi i get only userID (number). How can I resolve that? Do I add a table with UserID and user's name? Or what?

Many thanks for your suport

[v-lionel-msft · Accepted solution]

Hi @Giorgio67 ,

Can't you find the [name] column in this 'User Information List' table?

Best regards,
Lionel Chen

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

[v-lionel-msft · Accepted solution]

Hi @Giorgio67 ,

Has your problem been solved?

Best regards,
Lionel Chen

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

[v-lionel-msft · Accepted solution]

Hi @Giorgio67 ,

Can't you find the [name] column in this 'User Information List' table?

Best regards,
Lionel Chen

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

[Greg_Deckler]

Maybe this still works:
https://sharepointviews.com/hidden-users-list-in-sharepoint/

[Greg_Deckler]

Right, there is a hidden list in SharePoint that has the user information for all of those ID's. It's been a long time since I had to look that one up though, but it exists.