Forum Discussion
Power query
Hi, I am connecting a sharepoint folder to Power Query where I get reports uploaded every morning. All the reports have the first 10 rows that I do not need as it is just a broadcast data. I can...
Go to the Transform Sample query step. That is for 1 file, but it is processed for every file.
Use the Remove Top Rows and select 10 in that query.
Then when the files are combined, they will all start with row 11.
edhans
Community Champion
Community ChampionGlad to help. That Transform Sample Query is a bit hidden at first, but once you understand what gets applied to each file one at a time vs what you should do after they are all combined it gets easier.