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

[DebbieE]

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]

Hi @DebbieE ,

Whether this problem has been resolved?

Best Regards

Rena

[DebbieE]

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

[Anonymous · Accepted solution]

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

[amitchandak]

@ImkeF @ can you help on this