Statuscodename / statecodename - empty columns

[KjoniX2]

When loading data from Dataverse I get value for statecode and statecodename (e.g 0  and Active). We have one user where column for statuscodename and statecodename is empty.

We have exact same rights in dataverse and we import data on exact same way. We both have last PBI Desktop version. 

[v-yiruan-msft]

Hi @KjoniX2 ,

In order to make troubleshooting and give you a suitable solution, could you please provide the following info?

• Please check if there is any filter or view applied to the Dataverse tables that could be limiting the data being exported
• What's the data type of column [statecode] and [statecodename]?
• Refresh the data after load the data from Dataverse into Power BI and check if the data can be loaded

Create a Power BI report using the Dataverse connector - Power Apps | Microsoft Learn

Best Regards