CRM Stringmap

[Anonymous]

CRM Option Sets. 

 Hello Everyone,

I am trying to create a Power BI dashboard, I am getting my data from Dynamics 365 ONLINE withe the Dynamic conector. 

I noticed that in my CRM 2015 On-Premises database I have a table called StringMap, however I can't find that table on CRM Online 2016.

Where can I get the data which was in the StringMap table on Dynamics 365 ONLINE? I had tried, with EntityDefinitions, SystemUsers, and nothing.

Thank you,

Nicolas 

[Anonymous]

Here are the links

XRMToolbox – The PowerBI Option-Set Assistant

Map Dynamics CRM Option Set Values into Labels in Power BI

[Anonymous]

I am looking to match the combo box ids from Crm with the label of it. In the On Premise version, there was a table call: Stringmap that had all this names. Now iam using the Online version and this table in missing.

I will try with that option, 

Thanks. 

[v-jiascu-msft]

@Anonymous

Hi,

I can’t find it neither. Maybe it doesn’t exist in the online service. There is post you may refer to. https://community.dynamics.com/crm/f/117/t/196856

"I managed to get past this by creating  a relationship between AuditSet, EntityDefinition, and SystemUser tables in Power BI".

Best Regards!

Dale

[sdjensen]

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.

[Anonymous]

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?

[Anonymous]

Not sure if it is exactly what you are looking for.

XRMToolBox   has a "Power BI Option Set Assistant" for CRM.