I get below error when I try to use copy activity to copy data from .xlsx in azure blob storage to SQL table. Any quick help will be much appreciated.

ErrorCode=ExcelUnsupportedFormat,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Only '.xls' and '.xlsx' format is supported in reading excel file while error is ' at NPOI.POIFS.Storage.HeaderBlock..ctor(Stream stream)
at NPOI.POIFS.FileSystem.POIFSFileSystem..ctor(Stream stream)
at Microsoft.DataTransfer.ClientLibrary.ExcelUtility.GetExcelWorkbook(String fileExtension, TransferStream stream)'.,Source=Microsoft.DataTransfer.ClientLibrary,''Type=NPOI.POIFS.FileSystem.NotOLE2FileException,Message=Invalid header signature; read 0x78474B3452384D30, expected 0xE11AB1A1E011CFD0 - Your file appears not to be a valid OLE2 document,Source=NPOI,'

Hello @Manasa M ,

Thanks for the question and using MS Q&A platform.

As per the error message it seems your excel source data file format is not .xls or .xlsx. And currently, ADF will support these two types only. Kindly recheck your source file format once?

Could you please share your pipeline/ datasets json to go through configurations and following along so that we can repro scenario and help on resolution?