CSV import issue

[hmbi]

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!

[Anonymous · Accepted solution]

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.

[hmbi]

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?

[amitchandak]

@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