Data loading error

[Anonymous]

Hi.

I have received this error on a few of my columns in the transform data. 

When i click load more it will load all the data I need. Once I hit okay it will turn back to showing only 2 options. Does anyone know how to fix this? 

[amitchandak]

@Anonymous , this is not an error. Power query just shows this based on sample 1000 rows only. If you use load more ,it will load that

Same in case in data table, it limit it sample size to load it quickly