The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
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?
Solved! Go to Solution.
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. 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.