Forum Discussion
Solved
Appending from Folder - only selected rows
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...
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.
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
Community Champion
Community ChampionGlad to help Jiri_Slavik