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 delete the first 10 rows at the top but when the reports are joined below, moving from one date to another I get an error.
How can I make the reports that get uploaded every morning to automactically delete the top 10 rows?
Thank you very much
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.
3 Replies
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.
Glad 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.