Warning: Undefined array key "Play" in /homepages/7/d756825262/htdocs/clickandbuilds/365Community/wp-content/themes/Nexus/epanel/custom_functions.php on line 1812

Warning: Trying to access array offset on value of type null in /homepages/7/d756825262/htdocs/clickandbuilds/365Community/wp-content/themes/Nexus/epanel/custom_functions.php on line 1812

Warning: Undefined array key "Play" in /homepages/7/d756825262/htdocs/clickandbuilds/365Community/wp-content/themes/Nexus/epanel/custom_functions.php on line 1826

Warning: Trying to access array offset on value of type null in /homepages/7/d756825262/htdocs/clickandbuilds/365Community/wp-content/themes/Nexus/epanel/custom_functions.php on line 1826
Dealing with OptionSet inside PowerBI in Dynamics 365 CE – Nishant Rana's Weblog - 365 Community

Dealing with OptionSet inside PowerBI in Dynamics 365 CE – Nishant Rana’s Weblog

Suppose, we have created a Power BI Report which makes use of OptionSet field.

It is on incident entity and we have selected priority code and state code option set fields. The problem is that we only get the value for them, so to get the label either we can manually specify it or use the plugin Power BI Option Set Assistant. We’d see both the methods.

Let us take state code field first and specify label for them manually.

In the Query Editor, select New Query and specify following…

Continue Reading Nishant Rana’s Article on their blog

Dealing with OptionSet inside PowerBI in Dynamics 365 CE – Nishant Rana’s Weblog

Blog Syndicated with Nishant Rana’s Permission

Author: Nishant Rana

Share This Post On