Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Line Break - CSV Files

Hi, 

 

I was trying to combine multiple CSV files, but I got the error that I have a column named "Comments" that actually is Long text where our customers provides feedback, my challenge is that everytime a customer used a line break, this made that Power Query Reads a new Row, instead of leaving all the information together on the last column named "Comments" 

 

I have tried already cleaning data with Trim and Cleaning Format options, but it does not work and still leaves the new Row only with the text due to the Line Break. 

 

Is there any way I can avoid this? Appreciate your help. 

 

Regards, 

 

MIchael Pinto. 

Need Help
  • v-janeyg-msft's avatar
    v-janeyg-msft
    5 years ago

    Hi, Anonymous 

     

    It’s my pleasure to answer for you.

    When importing files from a folder and combining them, you get several query objects.

    The object that you should adjust is the query that transforms the example file, you can find the option at the location similar to this screenshot:

    Best Regards

    Janey Guo

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

8 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Did you enable Line breaks as ignore quoted line breaks on CSV-import on the source 

    Appreciate your kudos!! Mark my post as solution if this helps.

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Hello! Thanks for your quick answer, I have been looking for something for the past 7 hours. 

       

      Just wondering, where can I pull out that menu? I am using my power Bi Desktop but when I loaded all the CSV files, it does not show me those options. Also, I tried to use the Option Change Source and Data Source Settings but it does not show that.

       

       

       

      What do I have to do to find that option? 

      • CNENFRNL's avatar
        CNENFRNL
        Community Champion
        5 years ago

        Hi, Anonymous , try to double click the Source step in the APPLIED STEPS area then that menu pops up

         

    • jxutj's avatar
      jxutj
      Advocate I
      1 year ago

      This should be the accepted answer!

  • v-janeyg-msft's avatar
    v-janeyg-msft
    Community Support
    5 years ago

    Hi, Anonymous 

     

    It’s my pleasure to answer for you.

    When importing files from a folder and combining them, you get several query objects.

    The object that you should adjust is the query that transforms the example file, you can find the option at the location similar to this screenshot:

    Best Regards

    Janey Guo

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • sarathD4s's avatar
    sarathD4s
    Frequent Visitor
    3 years ago

    Hi CNENFRNL , 

    i am having the same issue and i tried to do the steps you said but i couldnt find that option.

    I am loading all the files in a folder and combining it and tried double clicking the sorce and it is just showing the folder path, is there any other way to sort this issue