empty column in model

[xieli]

Hi everyone,

Have you experienced a issue that I have a normal table with 2 columns only, and it shows normal in Power Query, but when I loaded this table into model, the model show one of these two columns is completely empty without any data?

Any thoughts?

Thanks

[xieli]

Hi all,

I fixed this issue by myself, the issue was related to data type.

[amitchandak]

@xieli , If the column was not visible in power query, I doubt it should.

But if they are visible and have values, It means there are blank rows and values not visible in the power query sample.

Check values using sort or search