Forum Discussion
Solved
Extracting People Picker Usernames Without Affecting Stored Data or Performance
Hi,
I'm new to Power BI and I need some help, please.
I'm consuming data from a SharePoint Online list and I need to display the username in Power BI report. However, I'm getting an ID (a number) not a username.
I did read several threads saying this conversion, from ID to username, can change stored data or affect performance. Any change in the data can break a workflow attached to the list and I don't want that.
Thanks in advance.
3 Replies
- amitchandak
Super User
Thank you very much!
- lbendlin
in addition to pulling your list you also need to pull the "User Information List" from the same sharepoint. Link the tables by the ID field and then use the Title field from the User Information List for the name.
