Forum Discussion
CRM Stringmap
I am sure the table exists in the online version, but that Microsoft just don't give you access to it though their API. If you have a look at the Power BI content pack for CRM Online the developer of this pack also had the same issue hence he/she made static tables with the values of the drop-down lists which is really not a great solution - BI models should be dynamic and always get the values from the source.
Unbelievable!!
I can confirm that it is not possible to access the labels of the fields of custom options sets.
This functionality has already been requested from the product team through the following site:
Make user created option sets also available through the PickListMappingSet odata table
https://ideas.dynamics.com/ideas/dynamics-crm/1686453
If you are using Power Query (or the new Power BI Desktop designer) and you want to display the values of a picklist (option set) - you can get at all the standard option sets using the PickListMappingSet. Unfortunately option sets which you define yourself or which are part of a solution that you import are not included. It would be better if these were included in the odata endpoint as well. This is especially needed for Dynamics CRM Online where oData is the main entry point.
How is it possible?