Skip to main content

Notifications

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id : UYvZPs6drVBI7hQO28of96
Power Platform Community / Forums / Power Up Program - Power Up Final Challenge / label of global Choice...
Power Up Program - Power Up Final Challenge
Suggested answer

label of global Choice column mapped in PowerBI - missed labels in PowerBI

Like (2) ShareShare
ReportReport
Posted on 14 Mar 2025 04:52:33 by CU18100438-0 6
Hi,
I have a global Choice object and a multi-choice column in Dataverse for Shelter_Animal_Types. My issue is that when importing the data into Power BI, the labels are missing. How can I import and match the choice labels?
image attached.
 
Thanks
 
Fred
Categories:
Product Question
  • Suggested answer
    w.p Profile Picture
    w.p 602 on 14 Mar 2025 at 07:25:29
    label of global Choice column mapped in PowerBI - missed labels in PowerBI
    Option 1 from link, a simple one, but not dynamic.
    shelterTypes1 = 
VAR valuesList = SUBSTITUTE(Shelter[wp_sheltertypeIDs], ",", "|")
RETURN
CONCATENATEX(
    GENERATESERIES(1, PATHLENGTH(valuesList)),
    SWITCH(
        PATHITEM(valuesList, [Value], TEXT),
        "127770000", "Bird",
        "127770001", "Cat",
        "127770002", "Dog",
        "127770003", "Horse",
        "127770004", "Livestock",
        "127770005", "Reptile",
        "Other"
    ),
    ", "
)
     
  • Suggested answer
    Michael E. Gernaey Profile Picture
    Michael E. Gernaey 35,902 Super User 2025 Season 1 on 14 Mar 2025 at 06:19:31
    label of global Choice column mapped in PowerBI - missed labels in PowerBI
     
    Yeah its a bother for sure.
     
    Here are some written solutions. None of them are great though.
     
    Now in recent times though, just make sure in your environment that you went to Solutions and Selected Publish All Customizations. Don't select ANY solutions, just go there and do with none selected
     
    If that doesnt work take a look at these.
     
     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,508 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 65,382 Most Valuable Professional

Leaderboard

Featured topics

Product updates

Microsoft Power Platform Community release plans