Appending from Folder - only selected rows

[Jiri_Slavik]

Hi Everyone,

I am beginner to Power BI and I'd need help.

I am appending several Excel files from folder. This works well.

But my source excel files contain more rows than I need.

So I'd need to use only top 12 rows from each source file (before they append into one table).

I was trying to use "Remove Rows" function, but don't know how to apply it to source files. I could do it only in appended-table, but it doesn't function the way I need.

Could you help me, please?

Thank you, Jiri

[edhans · Accepted solution]

Are you using the Combine feature?

If so you will have a group in Power Query that looks like this:

Add the Keep Rows function for the top 12 rows to the "Transform Sample File" step. It will apply everything in that step to each file individually before they are combined in your main query.

[Jiri_Slavik]

Hi edhans,

super, it helped. Thank you very much.

I am combining files by Append Queries function and your solution works perfectly.

Have a nice day, Jiri

[edhans]

Glad to help @Jiri_Slavik