How do I use Sharepoint People field in PowerBI?

[slan2018]

Hello,

I have a Sharepoint list that has a People field (they're only choosing 1 name). When I import this into PowerBI it shows up as a number instead of a name. How do I get it to display the name? 

[lbendlin · Accepted solution]

You need to also import the "User Information List" table and join it on that ID.

[Bucheron]

Useless answer, you can get a people colum and expand it on Power BI -_-