Forum Discussion
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 can I import wrap text cell properly into power bi table.
Thank you!
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.
3 Replies
hmbi , is the text enclosed in double quote? Then this should not create a problem.
Also, check the character set while importing. You have option on left top of import bix, when data sample is displyed
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?
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.
