Imported Data from Azure DevOps and User Names Display as Long Number Sequence

[akizzie]

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. 

[Anonymous · Accepted solution]

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.

Odata results displaying user id values under certain columns instead of usernames when data importe...