Forum Discussion

jonclay's avatar
jonclay
Icon for Helper IV rankHelper IV
5 years ago
Solved

Problem displaying Dynamics CRM Option Set labels in Power BI reports when they are separated by a ;

Hi everyone, I'm attempting to display the values of a Dynamics 365 CRM Online Option Set in Power BI, but I'm having a problem. The Option Set values are, for some reason, hidden in Dynamics, so ...
Need Help
  • DataInsights's avatar
    DataInsights
    5 years ago

    jonclay,

     

    In Power Query, you can split a column into rows. This would enable each row to join to your manual table.

     

     

     

DataInsights's avatar
DataInsights
Icon for Super User rankSuper User
5 years ago

jonclay,

 

In Power Query, you can split a column into rows. This would enable each row to join to your manual table.