Can't see the display value of a choice column from a table in the Dataverse in power bi

[Anonymous]

I am having problems with the display of the Choices column(Dataverse data).
"Displayname" of the Choices field does not show anywhere in the imported data.

Instead, the "Value" was displayed. I need to replace all　”Value” to ”Displayname”.

I would like to use both PowerApps and PowerBI, but I am not comfortable with the current situation.
Can you please solve this problem?

Can't see the display value of a choice column fro... - Microsoft Power BI Community

Get Name for Dataverse choices column - Microsoft Power BI Community

[v-lili6-msft]

hi

I hadn't used Dataverse in power bi, could you share the Repro Steps for this problem?

which table does Choices column belong in? Please share some screenshots, that will be great help.

Regards,

Lin

[Anonymous]

@v-lili6-msft 

Thank you for your support.
I contacted Microsoft about this issue, but they said they can't make the display name appear, so I posted it here.
Screenshot is included in the question below.

Get Name for Dataverse choices column - Microsoft Power BI Community

All of the columns that I selected show the Value and not the display name.

[v-lili6-msft]

hi

you could refer to blog:

https://markcarrington.dev/2021/03/09/optionset-labels-in-power-bi-reports/

Regards,

Lin

[Anonymous]

@v-lili6-msft 

Thank you for your help.

I just check that article.

So the problem is that the label columns, dosen't show in data.

Without label columns, I do not think I can do this.

1. To start off with, remove all the other columns. Select the optionset value and label columns, click the dropdown arrow for “Remove Columns” in the ribbon, then click “Remove Other Columns”

[bhaskerkumar]

The content in the URL helped, we have to publish the table to see the choice value in PowerBI