Forum Discussion

karans's avatar
karans
New Member
3 years ago
Solved

Sudden "DelimitedTextBadDataDetected" Error

Hi All,    I am using a Data Pipeline to copy data from a fabric lakehouse into a fabric data warehouse. I have about 16 files, and I get a full historical extract of the files every week. So far i...
Need Help
  • arpost's avatar
    arpost
    2 years ago

    Anonymous and karans, doing the above proved useful as it showed some of the problem rows. The issue appears to be that the DelimitedText settings for the Copy Activity had a specific character as an escape character that shouldn't have been there. Not certain if those were defaults or if they were a result of processing the schema.

     

    Either way, I changed the escape character, and that fixed it for mine.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

I am facing the same issue, Just wondering how can I upload the file here. 

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Anonymous ,
Thanks for providing the csv files over an email.
But the original ask in this thread is related to error in pipelines. But you have mentioned that you are using dataflows. As this is deviating from the original ask , I would request you to create a new post with the error details.

It will definitely look into the issue and help you.

Thanks.