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).
This happens also with other fields.
Any ideas how can I change it to the country name?
Thanks!
*This post is locked for comments
Perfect! Thanks!
Please follow the below link to solve this:
www.inogic.com/.../working-on-lookup-field-of-dynamics-365-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!
#1
André Arnaud de Cal...
291,440
Super User 2024 Season 2
#2
Martin Dráb
230,520
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
