Forum Discussion
Option Set problem using Dynamics 365
We are experiencing the same issue and I am glad I found this kind of still open topic here which is from 2024...And I hope it is still monitored...When I push Data into Power BI from our MS 365 Environment (Dataverse) the option set names are no longer populated. This means - older option set names from the same option set are populated to Power BI and all recently added new values to this option set are only populated as their numerical value in Power BI but its name value returns null. I have tried that on different tables, different workbooks, different connectors and also with Direct Query and Import of the data.
For me it seems as if something was changed (more or less recently) on the Microsoft side which does not populate the newly added values but does so for older option set entries. I also checked if I did anything wrong on the optionlist itseld in PowerAutomate but there is not so much one can mess up by just adding new values to an existing option field list...As we are working with quite a number of option sets in our company this is an increasing issue and I hope there is a solution or workaround or fix.
Fun Fact....after DAYS and WEEKS of searching I have found the solution (at least for me) in another Post here here in the Forum...Yet so simple once you know what was the root cause. Usually I added new values directly in the column in the table and did not add the table in a solution, added the values and published the solution. Never felt it was necessary...well...seems it is. Here is the original blog post with the solution in...I added the column with my option set in to a solution, published it and tested a reload in Power Bi and all the value names were published...WOW...
https://community.fabric.microsoft.com/t5/Desktop/Can-t-see-the-display-value-of-a-choice-column-from-a-table-in/m-p/2080624#M774528