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

%3CLINGO-SUB%20id%3D%22lingo-sub-2700930%22%20slang%3D%22en-US%22%3ECan't%20see%20people's%20name%20when%20reporting%20a%20SharePoint%20List%20in%20a%20Power%20BI%20report%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2700930%22%20slang%3D%22en-US%22%3E%3CP%3EI%20created%20a%20column%20in%20my%20SharePoint%20List%20called%20%22Category%20Manager%22%2C%20and%20populated%20with%20people's%20names%20in%20the%20company.%26nbsp%3B%20After%20creating%20a%20Power%20BI%20report%20using%20this%20List%20as%20data%20source%2C%20I%20can%20only%20see%20numbers%20in%20the%20Category%20Manager%20column%2C%20not%20names.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3EI%20tried%20different%20lists%20with%20different%20report%2C%20the%20numbers%20corresponding%20to%20same%20person%20aren't%20the%20same.%26nbsp%3B%20So%20it%20looks%20like%20the%20numbers%20aren't%20from%20my%20company's%20employee%20database.%26nbsp%3B%3C%2FP%3E%3CP%3EWhat%20is%20it%20then%3F%26nbsp%3B%20How%20do%20I%20get%20the%20report%20to%20show%20people's%20name%20other%20than%20a%20number%3F%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22StuDaMan_0-1630379010748.png%22%20style%3D%22width%3A%20102px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F306851iF441E7FC33956E61%2Fimage-dimensions%2F102x291%3Fv%3Dv2%22%20width%3D%22102%22%20height%3D%22291%22%20role%3D%22button%22%20title%3D%22StuDaMan_0-1630379010748.png%22%20alt%3D%22StuDaMan_0-1630379010748.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2700930%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EPower%20BI%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Frequent Visitor

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

 

0 Replies
www.000webhost.com