Error code =Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Only '.xls' and '.xlsx' format is supported in reading excel file while error is

Question

Using a Copy Activity in ADF to copy a xlxs file to azure sql:

Request URL: https://xxxxxxxxx.sharepoint.com/sites/Dataetc/_api/Web/GetFileByServerRelativePath(decodedurl='/sites/Dataetc/Billing/2023-02/Book1.xlsx')/$value

Error:

ErrorCode=ExcelUnsupportedFormat,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Only '.xls' and '.xlsx' format is supported in reading excel file while error is ' at System.Threading.Tasks.Task.ThrowIfExceptional(Boolean includeTaskCanceledExceptions) at System.Threading.Tasks.Task.Wait(Int32 millisecondsTimeout, CancellationToken cancellationToken)

Answer 1

Hi John Harrison,

Thank you for posting query in Microsoft Q&A Platform.

Is your API downloads some file here? If yes, then you need to consider using HTTP connector type dataset as source and in sink use ADLS gen2 or blob storage account dataset to download file to some location. Once, file downloads, use another copy activity to copy that data to Azure SQL.

From the above error message, it seems you are trying to accessing unsupported extension file for excel format. Supported extensions are '.xls' and '.xlsx .

Hope this helps. Please let me know how it goes and if any further queries.

---

Please consider hitting Accept Answer button. Accepted answers help community as well.