topic Re: Dataverse and importing Choice columns in Power Query

Dataverse and importing Choice columns

Lexicaltje — Wed, 27 Oct 2021 06:48:41 GMT

Hello all,

Having a recuring issue thats really driving me nuts. I have numerous dataverse tables feeding into power bi reports through Directquery (Although in this instance Directquery isnt the issue).

As we know when you import a table from dataverse where there is a choice column, you get both the unique number of the choice and the choice name. However, everytime i add a column to my dataverse table thats a choice and import this into Power BI, the choice name comes in as "null", even though there is data in there and the choice number is correct.

What is causing this?

Re: Dataverse and importing Choice columns

Lexicaltje — Wed, 27 Oct 2021 07:20:50 GMT

Just came across this;

https://docs.microsoft.com/en-us/powerapps/maker/data-platform/azure-synapse-link-choices-powerbi

Are you seriously tell me MS that this is the only way to do it? How ridiculous is that? I dont even understand what most of that means. You really need to fix this and make it simpler.

Re: Dataverse and importing Choice columns

v-jingzhang — Fri, 29 Oct 2021 08:48:13 GMT

Hi Lexicaltje

Try the solution in this thread: Can't see the display value of a choice column from a table in the Dataverse in power bi

After making changes to labels for a choice column, the table needs to have customizations published. So go to your Power Apps environment and click on Publish all customizations.

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

Re: Dataverse and importing Choice columns

v-jingzhang — Fri, 05 Nov 2021 09:52:43 GMT

Hi Lexicaltje

Does the method in my previous reply work? Or have you found other methods?

Regards,

Jing

Re: Dataverse and importing Choice columns

Lexicaltje — Mon, 08 Nov 2021 07:31:34 GMT

I found a different and much easier solution. I just had to click on "Solutions" and then "Publish all customisations". Then everything was fine.

Re: Dataverse and importing Choice columns

Anonymous — Wed, 21 Sep 2022 19:13:24 GMT

Do we have to do this for everytime we update a table?

Re: Dataverse and importing Choice columns

Kazu — Wed, 13 Mar 2024 17:44:30 GMT

Just wanted to say this saved my life although this is a very old post. Thank you so much!

Re: Dataverse and importing Choice columns

gates78 — Fri, 24 May 2024 18:21:44 GMT

thank you for the help.

I have same issue. I am trying to create a collection (PowerApps) from dataverse table that has a choice column. But no success. the column shows Unsupported data for evaluation. Please help.

Thank you in advance.

Re: Dataverse and importing Choice columns

SCWO — Thu, 31 Jul 2025 12:51:52 GMT

I'm facing the same problem, that I dont get the values from the choice columns when I try to query my dataverse tables from Fabric. I built a power apps for teams solution and want to build a power bi report. I tried the accepted solution and published all customisations. But somehow it won't work.
Does anybody know how I can check why this solution isn't working for me?