Can't see people's name when reporting a SharePoint List in a Power BI report

Copper Contributor

I created a column in my SharePoint List called "Category Manager", and populated with people's names in the company.  After creating a Power BI report using this List as data source, I can only see numbers in the Category Manager column, not names.  

I tried different lists with different report, the numbers corresponding to same person aren't the same.  So it looks like the numbers aren't from my company's employee database. 

What is it then?  How do I get the report to show people's name other than a number? 

Thanks 

StuDaMan_0-1630379010748.png

 

3 Replies
This information is stored in the extended information from the SharePoint connector, v1, in Power BI. I put together a resource page that has how to use Power BI with SharePoint. The first article is how to use Power BI to data mine SharePoint lists, and I show how to get to this information. See https://getstartedwithpowerbi.com for more information.