May 09 2021 08:36 PM
Hi, My requirement is to copy excel file from sharepoint to azure blob and I followed the below steps,
Step1: Created the pipeline with copy activity
Step2: Configured the source settings in the copy activity as per steps followed in the below Link
https://docs.microsoft.com/en-us/azure/data-factory/connector-sharepoint-online-list
Please Note that I am unable to perform this step
Except this I performed all the other steps
while clicking on the preview data on source data set in copy activity I am getting the following error
"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) at Microsoft.DataTransfer.ClientLibrary.MultipartSequentialReadSource.<ReadBuffersInSequential>d__5.MoveNext() at Microsoft.DataTransfer.ClientLibrary.TransferStream.ReadInternal(Byte[] buffer, Int32 offset, Int32 count) at Microsoft.DataTransfer.ClientLibrary.TransferStream.Read(Byte[] buffer, Int32 offset, Int32 count) at Microsoft.DataTransfer.ClientLibrary.SizeBoundedTransferStream.Read(Byte[] buffer, Int32 offset, Int32 count) at Microsoft.DataTransfer.ClientLibrary.TransferStream.Read(Byte[] buffer, Int32 offset, Int32 count) at ICSharpCode.SharpZipLib.Zip.Compression.Streams.InflaterInputBuffer.Fill() at ICSharpCode.SharpZipLib.Zip.Compression.Streams.InflaterInputBuffer.ReadLeByte() at ICSharpCode.SharpZipLib.Zip.Compression.Streams.InflaterInputBuffer.ReadLeInt() at ICSharpCode.SharpZipLib.Zip.ZipInputStream.GetNextEntry() at NPOI.OpenXml4Net.Util.ZipInputStreamZipEntrySource..ctor(ZipInputStream inp) at NPOI.OpenXml4Net.OPC.ZipPackage..ctor(Stream filestream, PackageAccess access) at NPOI.OpenXml4Net.OPC.OPCPackage.Open(Stream in1) at NPOI.Util.PackageHelper.Open(Stream is1) at NPOI.XSSF.UserModel.XSSFWorkbook..ctor(Stream is1) at Microsoft.DataTransfer.ClientLibrary.ExcelUtility.GetExcelWorkbook(String fileExtension, TransferStream stream)'. One or more errors occurred. The credential to read http file is invalid. The remote server returned an error: (401) Unauthorized."
while configuring the sink settings in the copy activity we observe that it is not supporting for excel format. However we tried with binary and csv format but no luck! Please help in this regard