Power Query reads All excel file rows

[Anonymous]

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, loads every 1'048.576 rows and working with it has been impossible.

Is not possible to format the data as table because this file comes every day and we want to avoid any manual transform. The idea to use Power Query is to automate this process. Take into account that every file has more data which means has more rows, but never will have a million. On worst case 10k by end of the year and then on january 2023 will be restarted.

Any clue how to just import the rows where it is located the data?

I already tried to remove empty rows, but on further steps still loads the million rows.

Thanks in advance

[artemus]

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).