Importing Excel Data using Powerflow

[BlessedCobba]

Hi All

I'm running into a really random issue when importing data from Excel using a dataflow

Below is a sample image of my data.
This issue i am facing is column I, whenever there is a description that has a large value with multiple rows etc, the dataload will error out and not bring in data from columns J, K, L. There error i will receive from the dataflow is cannot parse information in column J as dateformat however this column is not set to date neither is column K or L

When i shorten the value in column I (ie reduce to a single sentance) it will load in the data without an issue

no other row have this issue, only ones with really long values (current data set only has one row with long description)

Any help on how i can handle this issue would be appreciated
Cheers

[lbendlin]

What's the column type of your column I ? have you tried setting it to binary?

[BlessedCobba]

The column type is text,

if i convert to binary most of the descriptions error out