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