Forum Discussion
Retrieving values instead of GUID's when connecting to Common Data Service or Dynamics 365
Hi echo002 ,
Does the value of record exist in the source, such as some amout of entiy, such as 123, 200, 300,...etc ? Or you mean the index of record such as 1,2,3,..etc?
Based on this document: GUID field is a system generated unique identifier that ensures relationships are created for the create records where ambiguity or duplication may exist with other fields. you can create a relationship within PowerBI desktop between the two entities using a GUID field.
Best regards,
Hi Dong Li,
I'll take a look and see if that document can point me in the right direction.
To give you an example of what I'm running into currently. Lets say I want to make a Power Bi chart showing sales numbers for each salesperson. I'd make a connection to either CDS or Dynamics 365, select the relevent entities that I want to add to the chart. In this case it would be Opportunities and Users. Then I'd select the desired fields within each entity to add to the chart. The sales numbers come accross just fine since it's just numbers, but each salesperson is represented by the GUID associated with their name. So instead of the chart listing John Smith, it list him as DKFICK-CKDKSI-CKDISI-CKSKS or soemthing along those lines.
I'm trying to import this data in a way that it shows the displayed names for each record instead of the GUID.
Surprised that it's not easier unless I'm missing somehting...
Thank you,
Chris