Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago

CRM Stringmap

  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...
v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
9 years ago

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's avatar
sdjensen
Solution Sage
9 years ago

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's avatar
    Anonymous
    Not applicable
    9 years ago

    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?