Forum Discussion

FannyZ's avatar
FannyZ
Frequent Visitor
3 years ago
Solved

Text strings creates additional lines in csv extract

Hello,   I'm using power bi to merge multiple tables which one of them include some text manually entered coming from an excel sheet. On the excel sheet, we may have:  "02/03: Update from OEM 24/...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi FannyZ 

    Can you provide the expected result you want or the sample expected result?

    I'm a little confused by the problem you're described, do you mean you want to split the yellow parts of this image into each line?

     

    Best Regards!

    Yolo Zhu

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

  • FannyZ's avatar
    FannyZ
    3 years ago

    Hello,

     

    Thank you for trying to help. At the end, I solved the issue by removing every returned line in my excel data based. 

QuinnP's avatar
QuinnP
Advocate II
3 years ago

I found a simple solution to this problem. When reading the csv in power pivot, the QuoteStyle parameter of the Csv.Document function will determine whether newlines within a cell force the rest of the cell onto a new line or not. I changed this parameter from QuoteStyle.None to QuoteStyle.Csv and the issue was resolved.

I figured this out using the documentation for the Csv.Document function: Power Query Guide - Csv.Document.