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.

     

     

     

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

Hello there

Many thanks for your reply. I'll try that out later today, but it sounds as though it'll work.

Best wishes
Jon