issue retrieving choice column values.

[Anonymous]

Hi, 

I am using dataverse as backend and from power BI I am trying to import data. Upon importing data notice the columns which had choice values is only showing as choice numbers rather than its actual value. How to view the values in power BI. 

pls advice. 

[v-yalanwu-msft]

Hi, @Anonymous ;

 In Navigator, You could select the data you require, then either load or transform the data.

Here is  the offical document.

Power Query Dataverse connector - Power Query | Microsoft Docs

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.