Email address from SharePoint list displaying as an ID

[arunnar]

Good evening,

I'm currently building a Power BI report that displays actions against an owner. Its being built over an existing SharePoint site which has a field called ‘Agent’, this field uses the company global address list. When importing the data in to Power BI, the Agent field changes from the email address to a number in a column called ‘Agent ID. I am not sure if this number is a position of the email address in the global address list.

Has anyone come across this issue and if so is it possible to resolve in Power BI or does it need to be sorted at source in the SP list settings? 

[arunnar]

Manage Relationships function in Power BI Desktop is greyed out.

[amitchandak]

@arunnar , refer if these two can help

https://community.powerbi.com/t5/Desktop/How-to-display-an-assigned-user-in-a-sharepoint-list-in-Pow...

https://community.powerbi.com/t5/Power-Query/Email-address-from-SharePoint-list-displaying-as-an-ID/...