Extracting People Picker Usernames Without Affecting Stored Data or Performance

[efebo]

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.

[amitchandak · Accepted solution]

@efebo , refer if this can help

https://whitepages.unlimitedviz.com/2018/01/using-power-bi-to-report-on-person-fields-in-sharepoint/

[efebo]

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.