Hi @David ,
Welcome to Microsoft Q&A forum and thanks for your query.
Unfortunately this there is no direct way to achieve your requirement within ADF to remove the row grouping. You will have a do it either outside ADF before processing file to ADF pipeline or you could try to utilize ADF custom Activity or Azure Function activity and write your own code to remove the row grouping and then have the actual copy data activity to copy data to your desired sink.
Hope this info helps. Do let us know if you have further query.
Please don’t forget to
Accept Answer and
Up-Vote wherever the information provided helps you, this can be beneficial to other community members.