Power BI Exchange

Please login or click SIGN UP FOR FREE to create your PowerBIUG account to join this user group.
Expand all | Collapse all

How to filter Power BI report with Multiselect field in Dynamics CRM Online database

  • 1.  How to filter Power BI report with Multiselect field in Dynamics CRM Online database

    Posted 24 days ago
    Hi All,

    I am trying to filter the Dynamics CRM Opportunity report where one of the fields in Dynamics CRM is multi-select option set.
    As this field is not available in the query, I am storing values selected in the Multislect option set in CRM into text field on Opportunity with comma-separated values.

    Now I want to filter all opportunities with options that I have in multi select optionset.

    ------------------------------
    Rajashree nanaware
    ------------------------------
    Conference-PBI_200x200


  • 2.  RE: How to filter Power BI report with Multiselect field in Dynamics CRM Online database

    Top Contributor
    Posted 24 days ago
    Hi !

    You need to define a new query to get this option set value from Dynamics & load this as your dimension in your Data Model.

    Connect your dimension to Fact table based on option set value (ID) key

    Regards,

    ------------------------------
    Hasham Bin Niaz
    Director Data & Analytics
    Karachi, Pakistan
    ------------------------------

    Conference-PBI_200x200