Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
lnpapin
Helper I
Helper I

Can't see the display value of a choice column from a table in the Dataverse in power bi

‎02-08-2021 09:09 AM

I have imported tables from de Dataverse connector in PowerBI desktop, in that table i have a choice column called cr6bc_q3.  I only can show the value and not the name of the choice selected by the user in the powerapps.  Need help please

My table

lnpapin_0-1612804030449.png

My choice:

lnpapin_1-1612804054194.png

My result in power bi:

lnpapin_2-1612804072556.png

 

Thanks for the help!

 

Labels:
Message 1 of 22
40,706 Views
1 ACCEPTED SOLUTION
rtbergin
Advocate I
Advocate I

‎09-16-2021 07:37 AM

Thank you @hannibalmads! This solution worked for me! No more workarounds 🙌

 

@GrantR I am also working within a Dataverse for Teams environment. And the Publish all customizations worked, however it was a bit tricky to find. Below are some screenshots that should show you how to get there.

 

rtbergin_0-1631802883801.png

rtbergin_1-1631802912116.png

View solution in original post

Message 14 of 22
38,568 Views
21 REPLIES 21
Anonymous
Not applicable
In response to v-kelly-msft

‎02-10-2021 02:08 AM

Hello, I experience the same issue as the user above.

 

The table should show the value of the choice. That is, each choice defined in Dataverse has an ID (numeric) and a value (text string). In the example above, the ID shows in the column cr6b_q3 and the value should appear in the column cr6b_q3name, but the name column remains empty. 

Message 3 of 22
29,812 Views

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

View All
Top Solution Authors
View All