Forum Discussion
Replace/Translate UserID's into UserNames
1) I have imported a database table into Power BI , and it contains "UserID" values
2) I have exernal CSV file that contains UserID and UserName columns
3) Now, i would like to replace/translate all my USER ID values with UserNames in PowerBI table
Ex: my CSV table
UserID UserName
AAA0000 Alice
BBB0000 Bob
please let me know your thoughts
you can do all that in Power Query. Either replace the value in the existing column with the value of the merged column and then remove the merged column, or remove the existing column and rename the merged column to the name of the original column.
9 Replies
In your Power Query steps use "Merge Tables" to combine these two sources into one.
hey lbendlin , I have merged as a new table , but new columns appearing the main report , to better understand i just reframed my question here in reply , as i could not able to edit my old one
1) I have imported a database table into Power BI , and it contains "UserID" values
2) I have an external CSV file that contains UserID and UserName columns
3) Now, I would like to replace/translate all my USER ID values with UserNames in PowerBI table
4) Columns already present in my main Power BI report
user ID manager userID business owner ID
AAA000 AAA000 AAA000
BBB0000 BBB0000 BBB0000Ex: my CSV table
UserID UserName
AAA0000 Alice
BBB0000 Bob
how can I replace/map the USerID column wih userName column values wherever it matches
My final table should be as below
user ID manager userID Business owner ID
Alice Alice Alice
Bob Bob Bobplease let me know your thoughts
my thoughts have not changed from my earlier reply.