Forum Discussion
Solved
CSV import issue
Hi, I am trying to import a csv file which got wrap text in some rows/fields. Once data is imported it's showing error values in corresponding cells and creating an extra row with null values. How c...
Hi hmbi ,
Please try to wrap newline text in double quotes.
Best regards,
Community Support Team_ Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
no, its not enclosed in double quotes. I wasn't also aware of wrap text intially. After seeing the error on powerBI, I did check the file manually. What do you mean by charater set, is it File Origin? Which file orgin supports wrap text?