Forum Discussion
efebo
6 years agoFrequent Visitor
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 num...
- 6 years ago
efebo , refer if this can help
https://whitepages.unlimitedviz.com/2018/01/using-power-bi-to-report-on-person-fields-in-sharepoint/
lbendlin
Super User
6 years agoin 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.