Power Query not showing up with name of choice from Model Driven App

[phoebepage]

Hi everyone,

I am importing data to Power BI from a dataverse table on a model driven app. Normally when I import choices it comes up with a column that has the autogenerated number for the choice, alongside a column with the name of the choice. 

For some reason this is no longer working for me. When I import a countries list (selected as a choice in model app) it comes up with just the number code. Anyone know how I can fix this? 

[v-cgao-msft]

Hi @phoebepage ,

Are you using Dynamics 365 Online Connector to connect to a data source, if so, try using the Dataverse Connector.

The Dataverse connector can bring in both the unique integer field and the description field.

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum