Forum Discussion

VoltesDev's avatar
VoltesDev
Icon for Helper V rankHelper V
4 years ago
Solved

Data from Dataverse Choice column

Hi guys,   Need some clarification. I'm using Dataverse as my datasource, when my table have a Choice column like below: And this collumn/fields accept multiple value, so the data will be li...
Need Help
Show and Tell
  • VoltesDev's avatar
    VoltesDev
    Icon for Helper V rankHelper V
    4 years ago

    Hi MFelix 

    But that document is for getting data from Datalake (which probably the source is Dataverse). 

    My report datasource is directly to Dataverse, by using the Dataverse buton ->

     

     

     

    Thanks

    • MFelix's avatar
      MFelix
      Icon for Super User rankSuper User
      4 years ago

      Hi  , 

      On this post I have found an answer some time ago

      https://community.powerbi.com/t5/Desktop/Can-t-see-the-display-value-of-a-choice-column-from-a-table-in/td-p/1652535

       

       

      So you have some older choice fields which are working correctly, but newly created ones don't?

       

       

      The answer is this one:

      This is a by-design scenario as Dataverse store Choice type value in numeric. As a workaround, mapping relationship between on choice type value can be exported via another API call, please try using Power BI Web connector and access source link via below:

      https://<environmentName>/api/data/v9.2/EntityDefinitions(LogicalName='<TableName>')/Attributes(LogicalName='<Choice Name>')/Microsoft.Dynamics.CRM.PicklistAttributeMetadata?$select=LogicalName&$expand=GlobalOptionSet($select=Options)

      where environment name = org12345678..api.crm6.dynamics.com

      Essentially adding another table with the value/name pairing and  joining to the original table.   I have about 12 choices so far in my database, so this is painful. 

      VoltesDev

      • Anonymous's avatar
        Anonymous
        Not applicable
        3 years ago

        With a lot of searching I was finally able to bring in the data using the web connector, what is the best approach to handling the join, with a field with multiple selected choices?