Hi Community,

I am getting an error when trying to run my adf pipeline and data flow. My data flow reads from an excel source, where the sheet has 1,048,576 records (max excel sheet can have). 

For some reason, I get an error, and after trial and error method, noticed that the data flow runs perfectly when reading data sample around 998,997th record, but throws the below error, if I sample more or disable the data sampling.

Job failed due to reason: Failed to read data from excel file: abfss://<blob container>/<filename>.xlsx with error message: For input string: “1e6” – java.lang.NumberFormatException: For input string: “1e6”

I checked the excel file manually, but the records seem to be perfectly okay. Is this a limitation, or any insights might be appreciated.

​Hi Community, I am getting an error when trying to run my adf pipeline and data flow. My data flow reads from an excel source, where the sheet has 1,048,576 records (max excel sheet can have).  For some reason, I get an error, and after trial and error method, noticed that the data flow runs perfectly when reading data sample around 998,997th record, but throws the below error, if I sample more or disable the data sampling.Job failed due to reason: Failed to read data from excel file: abfss://<blob container>/<filename>.xlsx with error message: For input string: “1e6” – java.lang.NumberFormatException: For input string: “1e6” I checked the excel file manually, but the records seem to be perfectly okay. Is this a limitation, or any insights might be appreciated.  Read More

​