Forum Discussion
Problem between Power bi & Dynamics 365 field
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.
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-within-powerbi
2 Replies
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
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-within-powerbi
