Forum Discussion
Description user name
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
Hi Giorgio67 ,
Can't you find the [name] column in this 'User Information List' table?
Best regards,
Lionel ChenIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Giorgio67 ,
Has your problem been solved?
Best regards,
Lionel ChenIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
4 Replies
- Greg_DecklerCommunity Champion
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.
- Greg_DecklerCommunity ChampionMaybe this still works:
https://sharepointviews.com/hidden-users-list-in-sharepoint/ - v-lionel-msftCommunity Support
Hi Giorgio67 ,
Can't you find the [name] column in this 'User Information List' table?
Best regards,
Lionel ChenIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- v-lionel-msftCommunity Support
Hi Giorgio67 ,
Has your problem been solved?
Best regards,
Lionel ChenIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.