Problem between Power bi & Dynamics 365 field

[Anonymous]

Hi,

We loaded data from our Dynamics 365 CRM but the problem is that some field in Dynamics are field with multiple choices for example the field "country or region" in Dynamics as you can see below 

But in power bi those field show only numbers and to be more precise those numbers are the value of the options choosen by the user so in this case it will show the value "100,000,007" for South America. and not the label so for example here "South America" which is what we really need to see and I don't know how to do in order to see my label,

thanks you for the help.

[Stachu]

I'd assume that there is another table that you need to import that has both codes and descriptions of the countries and regions, then with proper joins on the codes  you could use the descriptions in the visuals

[Anonymous · Accepted solution]

Thank you for your answer, I followed this solution yesterday while I was waiting for an answer and it worked perfectly ! https://community.dynamics.com/crm/b/365lyf/archive/2017/05/13/how-to-use-dynamics-optionset-labels-...