Forum Discussion

xieli's avatar
xieli
Frequent Visitor
3 years ago

empty column in model

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

Need Help

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    3 years ago

    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 

  • xieli's avatar
    xieli
    Frequent Visitor
    3 years ago

    Hi all,

     

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