Show displayname not uuid

[DRossi]

Hi there,

I have a Dataverse table that has a column that looks up Entra, to select a user that has been assigned a survey.

This is displaying as some sort of ID or UUID. What do I need to do to get the Display Name instead of the UUID, in Power BI?

Thanks

[DRossi · Accepted solution]

I've resolved this by loading the systemuser table, and creating a relationship between the person field, and the azureobjectid column.

[Anonymous]

Hi @DRossi 

Based on the information you have offered, did you use the Common Data Service (Legacy) connector?, it is better that use the dataverse connector, and when using lookup column, it should return guid and related name, you can refer to the following link.

https://learn.microsoft.com/en-us/power-apps/maker/data-platform/data-platform-powerbi-connector?tab...

https://learn.microsoft.com/en-us/power-apps/maker/data-platform/data-platform-powerbi-connector?tab...

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[DRossi]

Hi @Anonymous 

I have used the Dataverse connector. I've checked the table in Power BI and there is no display name, as suggested in the docs you posted.

I checked other Choice columns that I have and I confirm that it shows the name of the choice.

However, for this person lookup, it does not.