How can i import a csv starting with row 2?

[n8schicht]

Hello,

I have a CSV which i have to edit every day.

In the first row there are some status informations and they are not relevant for the table.

at row 2 the table starts.

But how can i import this in powerquery.

Now my workaround is:

- open it in open office

- remove first row

- import it with powerquery

but is there a better way? 

thank you!

[MFelix]

Hi @n8schicht ,

The answer given by @ElenaN  is a great option but I'm assuming you are not proeficcient in query editor and advance editing, best option would be to just filter out the row 2 from your dataset, when it's uploaded to the model it will only return the last step of your query.

Regards,

MFelix

[ElenaN]

Hello,

You can use the function Table.Skip to remove first needed rows. (after loading the initial/unmodified file in Power Query)

https://docs.microsoft.com/en-us/powerquery-m/table-skip

Regards,

ElenaN