This article is about the workaround which a user can adopt. If user want to populated the CRM Option Set Label in report.
Power BI suite has a limitation that it shows the CRM option set Value not Label.
Please refer the previous blog(Power BI with Microsoft Dynamics CRM) for understanding how to establishing a connection between Power BI suite and Dynamics CRM for loading a data into Power BI.
Suppose, a you wants to create a report with Account Name and Region field.
Considering, Region is an option set field.
For getting the option set label, you need to create a dummy query where you need to map the Option Set Labels and Values.
Click on the Edit Queries button on the Menu bar. The below screen will pop up, right click on the Queries.
New Query –> Select Blank Query option
A table would get created. Refer the below query format and paste it in the editor.
= #table(
{"Value","Label"},
{
{100000000, "APAC"},
{100000001, "EU"},
{100000002, "NA"}}) 
You can rename the table by right clicking on it. Choose Rename.
Click on Close & Apply button, select Close & Apply option.
This will load the new table with columns, and bring you back to Report.
After this you will need to establish a relationship between the Account and Region. Click on “Model” as shown in the below image in yellow box.
Click on “Manage Relationships” button. Below screen will appear now click on “New” button for creating relationship
Select the tables between which you want to create a relationship. Like Account and Region in my case. As I want to populate the Account Region option set label in the report.
Next click on the column which has the similar data in both the tables for mapping. Then click “OK” button.
Clicking on “OK“. The below screen will appear where you can see the relationship which got created. Click “Close” button.
Coming back to Model, you can now view a link between the two tables.
Click on Report and select the Label field from the Region Table.
Learning Refresh 