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

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
Catalizt
Microsoft Employee
Microsoft Employee

vso identity fields converted to weird text strings

Hi there! 

I'm using the OData connector to pull VSO work item data into Power BI. 

Unfortunately, for some reason the contents of the "Identity" fields (e.g. Assigned to) are being converted to long alphanumeric strings.

Here is how the data appears in VSO

 Assigned to Lizzie.PNG

Here is how that data appears in Power BI.

Assigned to PBI.PNG 

 

I'm sure it's user error. Anyone know what my error might be? 

Thank you! 

 

1 ACCEPTED SOLUTION

Thank you!

Unfortunately I had several fields that all needed this matching so I've created columns using the LOOKUPVALUE function. Works like a charm!

 

Assigned To = LOOKUPVALUE(Users[UserName],Users[UserSK],WorkItems[AssignedToUserSK])

View solution in original post

4 REPLIES 4
Greg_Deckler
Super User
Super User

I wonder if that is a user unique id and you need to pull in another table to relate the user information to that unique id.



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...

Yes! 

I found the "Users" table and have brought it in. 

I think the next thing to do is create calculated columns in my original table which contain the related value. 

Example: 

Assigned to = (RELATED('Users'[UserName]))

 

Is there a better way? 


@Catalizt wrote:

Yes! 

I found the "Users" table and have brought it in. 

I think the next thing to do is create calculated columns in my original table which contain the related value. 

Example: 

Assigned to = (RELATED('Users'[UserName]))

 

Is there a better way? 


@Catalizt

So I think the assignment table and user tables has a proper many:one relationship.

 

Besides creating a calculated column, you can do nothing. Then in a chart, like table chart, drag some fields from assignment table and also the name from user table, the relationship would find the related username.

 

Or you can create some measure just like 

Measure  =
CALCULATE (
    SUM ( assigment[value] ),
    FILTER ( assigment, RELATED ( user[username] ) = "name1" )
)

 

 

Thank you!

Unfortunately I had several fields that all needed this matching so I've created columns using the LOOKUPVALUE function. Works like a charm!

 

Assigned To = LOOKUPVALUE(Users[UserName],Users[UserSK],WorkItems[AssignedToUserSK])

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.