How to see more then 1000 rows in Power Query Editor

[IraWatt]

How do you see the entire dataset in Power Query Editor as in editor mode it just shows the first 1000?

[Syndicate_Admin]

This solution didn't work for me, any other alternative?

[Samarth_18 · Accepted solution]

Hi @IraWatt ,

You cant see more than 1000 rows in power query but to analyze it further you can do following steps,

check for left bottom corner like below 

then click on column profiling based on 1000 rows and select below option

Thanks,

Samarth