We get Excel files uploaded to our Blob storage from another group. We are trying to copy the contents to an Azure SQL table. The issue I am having is with the format of the Excel file. It is using row groupings and is causing errors when being read by the ADF dataset 'Object reference not set to an instance of an object'
If I manually remove the row groupings and resave the file, it reads fine in the copy activity in the pipeline. Is there a way in ADF to get rid of the row groupings or am I going to have to write a separate process to manually do this?