cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Gueyemo Frequent Visitor
Frequent Visitor

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

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

1 ACCEPTED SOLUTION

Accepted Solutions
Gueyemo Frequent Visitor
Frequent Visitor

Re: Problem between Power bi & Dynamics 365 field

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

2 REPLIES 2
Highlighted
Super User
Super User

Re: Problem between Power bi & Dynamics 365 field

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

Gueyemo Frequent Visitor
Frequent Visitor

Re: Problem between Power bi & Dynamics 365 field

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