Error for a data copy activity in a pipeline within Microsoft Fabric - ZIP entry size is too large

[IgorM]

I'm trying to import an XLSX file (with a size of about 300 MB) into a table using a pipline in Microsoft Fabric. There are 700k rows of data in the file. When I try to run the pipeline I get the below error. I tried to run it for the same file but with rows of data reduced to c. 1000 and it run just fine. This is the error I get when I run the pipeline for the original file:

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.OpenXml4Net.Util.ZipInputStreamZipEntrySource.FakeZipEntry..ctor(ZipEntry entry, ZipInputStream inp)> 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)'.,Source=Microsoft.DataTransfer.ClientLibrary,''Type=System.IO.IOException,Message=ZIP entry size is too large,Source=NPOI.OpenXml4Net,'

[NandanHegde]

Glad that it helped!! 

https://learn.microsoft.com/en-us/fabric/get-started/decision-guide-pipeline-dataflow-spark

Please upvote and accept as solution as it might benefit other community members as well

[NandanHegde · Accepted solution]

Can you try using Dataflow Gen 2 to read the original file and confirm?

The issue is similar in PaaS ADF, similar thread :

https://stackoverflow.com/questions/67376837/how-to-access-power-bi-service-in-multi-tenant-scenario

[IgorM]

Hi, I've just tried Dataflow Gen 2, as per your suggestion, and it worked fine - the data was loaded successfully to the Lakehouse.