Common Data Services User data coming as a Guid in Power BI

[Anonymous]

Hello Folks,

I am getting the data from CDS and the User Data Type data is coming as GUID in Power BI - any clue why is it happening so ?

Custom entity

System Entity: Account => same bhaviour

Thanks.

[Anonymous · Accepted solution]

Found the solution – we will have to load the Systemusers table from CRM apart from Custom entity to get User fullname and any other fields.

Then after use LOOKUPVALUE function to map and find the FullName, Email, etc.

see more: https://www.inogic.com/blog/2018/10/working-on-lookup-field-of-dynamics-365-in-power-bi/