Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
ReneeO
New Member

Convert Employee Name ID from a number to text

Is there a way to change an Employee named from numbers to text so that I can see the employee's name?

5 REPLIES 5
vanessafvg
Super User
Super User

i think you need to give more info here

 

1. what data to you have

2 you would probably need to link the number to another table to get the name

 

but thats just a huge assumption because what are you asking?





If I took the time to answer your question and I came up with a solution, please mark my post as a solution and /or give kudos freely for the effort 🙂 Thank you!

Proud to be a Super User!




I am very new to Power BI, so I will give as much information as I can.  We have a Sharepoint list capturing ideas as employees submit it.  Their names appear in the Sharepoint list, but they convert to Employee ID numbers in the power BI queries.  We are assuming that the ID's are being assigned through our Active Directory.  The goal is to be able to create a table in Power BI so we can track how many ideas employees are submitting, but would like to see their names.  Thank you for any help you can give!

Ok so what you need to do is find the table in sharepoint that stores the users.  So you need to bring both those tables into power bi , the user table and the list table  and then create a relationship between the tables via the id's and you will then be able to bring back from the user table the employee name.

 

I have done something similar before but for the life of me can't remember what the name of the sharepoint table is.  I think its called userinfo or something.  It was in a previous role so i can't access it.

 

 

 

 





If I took the time to answer your question and I came up with a solution, please mark my post as a solution and /or give kudos freely for the effort 🙂 Thank you!

Proud to be a Super User!




Great!  Thank you so much!

@ReneeO

We have testList and there's a field "empName" which is a person type in the list.

 

Capture.PNG

 

And in Power BI desktop, when connecting to the Sharepoint List, I get the empName which has a record type and I can find the name after expanding the record.

 

Capture.PNG

 

Isn't this the same case in your scenario?

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.