Forum Discussion
Query does not update Dataverse Choices column Label.
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
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.
2 Replies
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.
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?
