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

John Harrison 0 Reputation points
2023-03-21T15:51:34.43+00:00

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)

User's image

User's image

User's image

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,464 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,544 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. ShaikMaheer-MSFT 37,896 Reputation points Microsoft Employee
    2023-03-23T06:45:22.5533333+00:00

    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.