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 i...
Need Help
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.