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?
