Forum Discussion
Getting code instead of data for a CRM field
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 ,
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.
2 Replies
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 ,
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.