Forum Discussion

DebbieE's avatar
DebbieE
Icon for Community Champion rankCommunity 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 e...
Need Help
  • 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

Anonymous's avatar
Anonymous
Not applicable
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