CRM Stringmap

Question

&nbsp;CRM Option Sets.&nbsp;&nbsp;&nbsp;Hello Everyone,&nbsp;I am trying to create a Power BI dashboard, I am getting my data from&nbsp;Dynamics 365 ONLINE withe the Dynamic conector.&nbsp;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.&nbsp;Thank you,&nbsp;Nicolas&nbsp;&nbsp;&nbsp;&nbsp;

sdjensen · Answer

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 · Answer

Not sure if it is exactly what you are looking for.&nbsp;XRMToolBox&nbsp;&nbsp; has a "Power BI Option Set Assistant" for CRM.&nbsp;

anonymous · Answer

Here are the links&nbsp;XRMToolbox – The PowerBI Option-Set AssistantMap Dynamics CRM Option Set Values into Labels in Power BI

anonymous · Answer

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 · Answer

Anonymous&nbsp;Hi,&nbsp;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&nbsp;"I managed to get past this by creating &nbsp;a relationship between AuditSet, EntityDefinition, and SystemUser tables in Power BI".&nbsp;&nbsp;Best Regards!Dale

Forum Discussion

CRM Stringmap

CRM Option Sets.

6 Replies

Related content

Open mirroring versus Dynamics 365 CRM

Zoho CRM Power BI

Connect PowerBI to Zoho CRM

Fabric Dataverse/CRM Virtual Table Metadata Refresh

Dynamics 365 CRM data from PBI Desktop