Dynamics Custom Fields Label and Value Display

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-option-set-values-into-labels-in-power-bi 

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.