Getting code instead of Country Name in Power BI

(0) Share

Report

Posted on by Community Member

Hi,

I have connected my Dynamics CRM to PowerBI.

I get most of fields as they are shown in the CRM, but for some reason the field "Country", that in the CRM is entered as regular country names as "United States" or "China", is shown in PowerBI as the following:

2a3f6b00-8d3c-e811-a84e-000d3a2afa0f (different "code" for each country).

3173.country.png

This happens also with other fields.

Any ideas how can I change it to the country name?

Thanks!

*This post is locked for comments

All responses (3)

Answers (1)

Community Member on at

Like (0)

Report

RE: Getting code instead of Country Name in Power BI

Perfect! Thanks!
Verified answer

DynamicsCRMUser 50 on at

Like (0)

Report

RE: Getting code instead of Country Name in Power BI

Please follow the below link to solve this:

www.inogic.com/.../working-on-lookup-field-of-dynamics-365-in-power-bi
Suggested answer

Community Member on at

Like (1)

Report

RE: Getting code instead of Country Name in Power BI

Hello David,

Looks like your field _new_country_value is a lookup. You need to add table Country to Power BI and create relationship between Country table and your table.

Use GUID field in Country table and _new_country_value in your Table to create a relationship.

After relationship is created you can choose CountryName field from Country table.

Hope it helps!