Dynamics Custom Fields Label and Value Display

[DNettem]

Hi All,

I connected CRM Dynamics Online on to Power BI desktop version and I'm trying to display the name values of custom fields that are created on the account side.

I have created a custom field that looks at customer type, such as contractor, CC account, etc.

When I connect to Power BI and pull the field it displays the value instead of the label.

Is there a way to change this so that it will display the label name instead?

As a work around I created an excel sheet with the label and values and linked them to get it to display.  It works for now, but it's not a viable solution in the long run for continual build-out.

[Eric_Zhang]

---

@DNettem wrote:

Hi All,

I connected CRM Dynamics Online on to Power BI desktop version and I'm trying to display the name values of custom fields that are created on the account side.

I have created a custom field that looks at customer type, such as contractor, CC account, etc.

When I connect to Power BI and pull the field it displays the value instead of the label.

Is there a way to change this so that it will display the label name instead?

As a work around I created an excel sheet with the label and values and linked them to get it to display.  It works for now, but it's not a viable solution in the long run for continual build-out.

---

@DNettem

I'd guess that might be some limitation. Can you go to "query editor" to see if the label contains in the source? By the way, how you link excel to Dynamics CRM?

[DNettem]

Hi Eric,

I do not have labels in the system, it only shows the number value instead in the query editor for accounts.

I found this post which shows that you can connect through the picklistmapping:

https://community.dynamics.com/crm/b/scaleablesolutionsblog/archive/2016/03/25/map-dynamics-crm-opti...

However, it brings over all values of all the custom fields.  Microsoft assigns the same values based on custom fields so I can have 1000001 come up under three different custom fields under accounts.  So, Power BI cannot create a relationship to the field since it is not unique.  I'm attempting to see if I can create an entity for each to appropriatley assign the labels.  Another work-around I found is to concat the fields within Power BI which allows for a unique ID to link to.  This is still requires hands on work in the query editor which I'm trying to avoid, outside of just assigning it to display the label.

I did not connect the Excel file into Dynamics.  I created an excel table with the IDs and label names, connected it to Power BI, and then established the relationship in Power BI.

[natiki13]

Hello! I have the same problem and it is very frustrating. 

Did you end up finding an automatic solution that fixes this issue?

I would apprecaite an update from you. 

Thank you

Natalie Zheleznova, TEAM International 

nataliez@teaminternational.com