Forum Discussion

erichuang's avatar
erichuang
Icon for Microsoft Employee rankMicrosoft Employee
4 years ago

How to get display value for Choices column when import data from Dataverse?

I try to use Dataverse as the datasource of power BI. In the Dataverse Table a column [Result] is Choices columns which means users can select multiple items from the list. In power BI side after i import data from dataverse i only can get integer values, which are comma separated about the column. but Choice columns which  provide a drop-down list of items to a user to make a single selection can presented as two columns to show both the unique value, and the display item value,it works fine.

May i know how to get the display value for the Choices columns?

Thanks so much!

Need Help

2 Replies

  • v-jingzhang's avatar
    v-jingzhang
    Icon for Community Support rankCommunity Support
    4 years ago

    Hi erichuang 

     

    Is it possible to share a screenshot of the current table you have (removing sensitive info)? Do you mean currently the choice list items are in one column and the display item (is it the item that one user selects?) is in another column? You can open Power Query Editor then transform the data there. 

     

    Best Regards,
    Community Support Team _ Jing

  • erichuang's avatar
    erichuang
    Icon for Microsoft Employee rankMicrosoft Employee
    4 years ago

    Thanks for you update.

    I get data from dataverse, the data like this in power bi side:

    Result

    860000,86001,86003

    If user choose more 3 item in dropdown list.

    But if user choose 1 item for another column like singleResult, then i will get two column in powerBi side

    singleResult        singleResultname

    860000                good

    860001                not bad

    860003                bad

     

    I can not get the key-value table, so i can not transfer it.