Forum Discussion
Power Query reads All excel file rows
Hi everyone, I'm struggling with how to handle importing an excel file which now has 3715 rows but when I import it using "from file" or "from folder", loads all 1'048.576 rows. Any step ahead, l...
You can use add a step with something like:
Table.FirstN(Source, [A] <> "")
where [A] would be a column, and "" would be what the blank rows are (could be null instead).