Forum Discussion
Power BI Query Editor shows some Dataverse choice columns with numerical value only
Hi N_TechWriter ,
Here are some steps you can try to resolve the issue:
Check the settings of the choice columns that are duplicated with “name” added to the end. Make sure that they are set to “local choice” instead of “global choice”.
Check the settings of the choice columns that aren’t duplicated and only return the numerical value. Make sure that they are set up correctly and have the same settings as the duplicated columns.
Try republishing the table and the choice tables, making sure to select “Publish all customizations” for each one.
Clear the cache in Data Cache Management Options in the Power BI desktop settings, and restart the program.
Use Microsoft Dataverse to detect duplicate records and merge - Power Platform | Microsoft Learn
Best Regards
Community Support Team _ Rongtie
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous,
I tried your suggestions and created other columns using "local choice". It seems that the duplicated columns with "name" added to the end is completely random. Sometimes the column is created, sometimes it is not. Sometimes it is created for a local choice, and sometimes it is created for a global choice.
Furthermore, the "name" column sometimes shows up 24 hours later for some and sometimes it never shows up.
Here's the thing, when I pass the table through a Power Automate action like 'Get a row by ID', I can see that the OData information is there in the body of the outputs.
Moving forward, my plan is to create tables with many duplicates of my choice columns with different Schema names, hope that one of them has the appropriate column created, then delete the columns that I don't need.
Thanks for your reply!