Forum Discussion
Removed rows not actually removed
When you remove top rows and promote headers in the main query, that applies only once for the combined data, not for each individual file.
If you want to perform transformations for each individual file, you should adjust the Transform Sample File query, instead of the main query.
The code in the Transform Sample File query, is directly linked to the function that is applied to all files.
Hi Anonymous,
I think you should turn on the last steps and click on apply the change. It seems like you finish added your custom steps but you are navigate to the previous history steps.
>>The Data view clearly shows those first rows despite them being removed in the query. Am I misunderstanding something or missing a step?
Power query will log operate steps, it not support to modify the original data source. On this basics, you can simply view your previous data of specific steps.
Regards,
Xiaoxin Sheng
Hi Anonymous,
I did turn on those steps and applied the changes, I clicked back through the steps to show for my post what wasn't happening.
- MarcelBeug
Community Champion
When you remove top rows and promote headers in the main query, that applies only once for the combined data, not for each individual file.
If you want to perform transformations for each individual file, you should adjust the Transform Sample File query, instead of the main query.
The code in the Transform Sample File query, is directly linked to the function that is applied to all files.