Forum Discussion

DebbieE's avatar
DebbieE
Community Champion
6 years ago
Solved

Carriage return in Comment column is causing columns after comments to be empty

I am working with a dataflow

 

If I test the data using a specific record by filtering at the beginning of the process just after importing the data from csv and promoting headers, in Power Query editor I see this

 

But in the File itsself looks like this

 

Note that its cut the comment at the carriage return and not brought though the other information for the other columns

 

When I check the comment in Notepad ++ it cuts off where the comment is added to a new line.

Is there aything I can do in Power Query Editor to fix this problem? 

 

I can see that Power BI may cut off the Comment itsself but to lose all the data after in the other columns is really odd

 

I tried the solution in https://community.powerbi.com/t5/Desktop/Replace-carriage-return-in-dataset/td-p/24900 right after importing csv but it hasn't made a difference

 

The step where the data is loaded looks like this

 

Csv.Document(#"Demo table csv_https://Customer sharepoint com/sites/DataStore/Shared Documents/General/", [Delimiter = ",", Columns = 13, Encoding = 1252, QuoteStyle = QuoteStyle.None])
 
is there anything I can do in this bit of code to help? I think its something to do with adding and changing the following?
 
QuoteStyle: Specifies how quoted line breaks are handled. QuoteStyle.None (default): All line breaks are treated as the end of the current row, even when they occur inside a quoted value. QuoteStyle.Csv: Quoted line breaks are treated as part of the data, not as the end of the current row.
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi DebbieE ,

    Please try to update the source code as below and check if it can display normally:

    Csv.Document(#"Demo table csv_https://Customer sharepoint com/sites/DataStore/Shared Documents/General/", [Delimiter = ",", Columns = 13, Encoding = 1252, QuoteStyle=QuoteStyle.Csv])

    Best Regards

    Rena

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi DebbieE ,

    Please try to update the source code as below and check if it can display normally:

    Csv.Document(#"Demo table csv_https://Customer sharepoint com/sites/DataStore/Shared Documents/General/", [Delimiter = ",", Columns = 13, Encoding = 1252, QuoteStyle=QuoteStyle.Csv])

    Best Regards

    Rena

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi DebbieE ,

    Whether this problem has been resolved?

    Best Regards

    Rena

    • DebbieE's avatar
      DebbieE
      Community Champion

      Yes you can mark this as resolved

       

      It turned out to be an issue before it even hit Power BI and had to be dealt with at source

       

      Debbie