Forum Discussion
Scroll to the 800000th row in Power Query Editor
The following M line is (wrongly) not cutting any row at the end of my source with about 800000 rows:
= Table.FirstN(#"Trimma il ""1"" finale dalle instestazioni",each List.NonNullCount(Record.ToList(_))>0)
I need to see the last rows of my source to understand what's wrong (what changed...) in my source.
How can I do?
1. Go to Transform tab - Reverse Rows
This will put your last rows on top and you can do the analysis.
After your analysis is over, then delete the Reverse Rows step.
2. Another way is issue this statement
=Table.LastN(#"Your previous step",10)
10 means that it will display your last 10 rows. You can replace 10 with whatever no.
3. Another way is insert an Index column. Then you can filter on this Index.
1 Reply
1. Go to Transform tab - Reverse Rows
This will put your last rows on top and you can do the analysis.
After your analysis is over, then delete the Reverse Rows step.
2. Another way is issue this statement
=Table.LastN(#"Your previous step",10)
10 means that it will display your last 10 rows. You can replace 10 with whatever no.
3. Another way is insert an Index column. Then you can filter on this Index.