Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

How to see more then 1000 rows in Power Query Editor

How do you see the entire dataset in Power Query Editor as in editor mode it just shows the first 1000?  
Need Help
  • Samarth_18's avatar
    Samarth_18
    4 years ago

    Hi Anonymous ,

     

    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

     

TomasAndersson's avatar
TomasAndersson
Icon for Solution Sage rankSolution Sage
11 months ago

I know I’m late to the party, but for anyone future troubleshooters: I had the same issue. Opening the Excel file, double-clicking a cell further down, saving, and closing it fixed the problem. It seems like Power BI sometimes only recognizes the first 1,000 rows until the file is “activated” this way.