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

Question

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

John Harrison 5

Mar 21, 2023, 3:51 PM

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

PRADEEPCHEEKATLA 90,576 Reputation points

Mar 31, 2023, 5:47 AM

Hi @John Harrison,

We received your feedback that the answer provided on the thread was not helpful.

Kindly let us know what we could have done better to improve the answer and make your engagement experience good. We are here to help you and strive to make your experience better and greatly value your feedback.

Our engineer has provided a detailed answer which has clear steps for which you are looking for.

If you wish, you may re-surveying/rating for the engagement you received on the thread. Your feedback is very important to us.

Looking forward to you reply. Much appreciate your feedback!

Regards,

PRADEEPCHEEKATLA-MSFT
Daniel Angulo 0 Reputation points

Aug 21, 2024, 7:31 PM

what was the resolution for this use case, I have a similar issue.

1 answer

Your answer

PRADEEPCHEEKATLA 90,576 Reputation points

Mar 31, 2023, 5:47 AM

Hi @John Harrison,

We received your feedback that the answer provided on the thread was not helpful.

Kindly let us know what we could have done better to improve the answer and make your engagement experience good. We are here to help you and strive to make your experience better and greatly value your feedback.

Our engineer has provided a detailed answer which has clear steps for which you are looking for.

If you wish, you may re-surveying/rating for the engagement you received on the thread. Your feedback is very important to us.

Looking forward to you reply. Much appreciate your feedback!

Regards,

PRADEEPCHEEKATLA-MSFT
Daniel Angulo 0 Reputation points

Aug 21, 2024, 7:31 PM

what was the resolution for this use case, I have a similar issue.

Answer 1

ShaikMaheer-MSFT 38,521 Microsoft Employee

Mar 23, 2023, 6:45 AM

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.

ShaikMaheer-MSFT 38,521 Reputation points Microsoft Employee

Mar 23, 2023, 10:28 AM

Hi John Harrison, If above answer not helps, Kindly share more details on your API, will it download a file? if yes, what kind of extension it has? Also, what kind of connector dataset you are using here? Because when we create REST connector dataset, it won't ask for formatter right? But your image shows its excel format.

AI Skills Fest

Share via

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

1 answer

Your answer