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.
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.
Thank you!