Make Power Query (insert data from folder) files delete or ignore first row

[Jyggalag]

Hi all,

I currently have a bunch of files that are 99% similar, except they have some different data in their columns. The first two rows will always look like this:

Unfortunately, the first row messes with the power query, so it returns this:

If I remove the first row, my file works such as intended and I can import my data. However, surely there must be some way to get Power Query to automatically delete or ignore the first row (row A1-X1 etc.) when it loads data, right?

I would truly appreciate some insight here!

Also moderators (@Fluff @Joe4) if I posted this in the wrong forum, apologies! I would like to kindly ask you to move it to the correct forum in such an instance.

Kind regards,
Jyggalag

 

[RoryA]

You need to modify your Transform Sample file query to skip the first row.

 

[Jyggalag]

You need to modify your Transform Sample file query to skip the first row.

How do I do that if I may ask? Apologies for the silly question, I just started using Power Query yesterday.

I tried going in here, but it's all greyed out:

 

[RoryA]

Wrong query. You want the one two rows above that. When you initially set this up, if you'd removed the top row, it would have applied to all files.

 

[Jyggalag]

Wrong query. You want the one two rows above that. When you initially set this up, if you'd removed the top row, it would have applied to all files.

Ah okay thank you Rory!

I can remove the files if necessary from the folder?

For now tho it seems like I can't do much in here either though:

Do I have to somehow change the formula here or?

 

[RoryA]

If I were you, I'd delete all of that and just start again from the beginning.

 

[Jyggalag]

If I were you, I'd delete all of that and just start again from the beginning.

How would I do that?

I removed the files from the folder now, but I am not sure on how to reset the folder that I am referring to with my pivot table (without creating the pivot table all over again and inputting a source).

I tried here, but it seems to get me stuck since there are no files in the folder now:

Sorry for the confusion!

 

[RoryA]

Put the files back in the folder, then click on the Sample File query and see if it's working.

 

[Jyggalag]

Put the files back in the folder, then click on the Sample File query and see if it's working.

Thank you so much for your patience Rory I tried it, but got this:

 

[RoryA]

Select the Source step (in the list on the right), then post a picture of that please.