Forum Discussion
Imported Data from Azure DevOps and User Names Display as Long Number Sequence
Hello,
I just imported some data from an Azure DevOps project using the OData Feed option. I want to create a dashboard that will show work items by assigned user but when I look at the "AssignedToUserSK" column, it just shows a random value instead of a name.
What is the reason for this and is there a solution? It appears to happen for all fields that contain a username.
Hi akizzie ,
If you want to see usernames in the Odate query instead of user id, you need add the columns AssignedTo.UserName, CreatedBy.UserName and ChangedBy.UserName . Then you can see the user name.
1 Reply
Hi akizzie ,
If you want to see usernames in the Odate query instead of user id, you need add the columns AssignedTo.UserName, CreatedBy.UserName and ChangedBy.UserName . Then you can see the user name.