Get data from folder, remove rows from each file in folder

Hi , Anonymous 

Please recheck you steps:

1.Get data from folder

2.Select “Transform Sample File”  and select   ‘Use First Row as Headers’   

If success , the transform Sample File will be as shown below:

3.Maybe there will be an error like this:

Please  delete the steps of “change type”

4.The final queries will be as shown below  and please click “Close &Apply”  

Here’s a sample I made:

Url: https://wicren-my.sharepoint.com/:f:/g/personal/michael_wicren_onmicrosoft_com/EsEeylz5jFtPv5n8uzVa2ikBi7MtEB7P_e5hbmF3V0VD3w?e=8qE6ba

If it doesn't meet your requirement, kindly share your sample data and expected result if you don't have any Confidential Information. Please upload your files to One Drive and share the link here.

Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.