Getting code instead of data for a CRM field

[Anonymous]

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).

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

Thanks!

[Anonymous]

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).

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

Thanks!

[v-yuta-msft · Accepted solution]

@Anonymous ,

Are the country names text format in dynamic CRM? In addtion, if you the type of country can't be changed in dynamic CRM. You can create an additional table like below:

_new_country_value	Country
2a3fb00-8d3c-e811-a84e-000d3a2afa0f	USA
…	…
…	…

Then click query editor, Merge the two tables based on column [_new_country_value] and then remove the [_new_country_value] column.

Community Support Team _ Jimmy Tao

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