Query does not update Dataverse Choices column Label.

[JanicAK]

Hi,

Building a report in Power BI Desktop, I realized that after updating Labels of a Choices column in Dataverse, these changes would not reflect in Power BI.

More concretely, I have a Choices column called "Category" and updated labels to include a number at the beginning. For example: "Health" -> "3 Health". Power BI still shows the old labels, in this case "Health".

So far I tried (in BI):

- updating the data

-  removing access permit from data source settings and reconnect with the datasource

- update the preview in query editor

- wait a few hours and retry the above

Someone knows what might be the issues? 

Thanks in advance. 

Best,

Janic

[kirstend]

I'm running into this same issue with a Dataverse for Teams table, and I don't see an option to publish any of those tables. Any ideas?

[Anonymous · Accepted solution]

Hi @JanicAK 

After testing, when  you change the label of the choice in dataverse, you need to publish the table. please make sure you publish the table after changing the choice label.  after publishing the table, then refresh in Power BI Desktop.

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.