Dataflows Gen2 – Import – Mashup - DataFormat Error

frithjof_v 

Thankyou for the suggestion of using keep rows -> keep errors.

All my other tests like importing into Excel did it "right". However DataFlows Gen2 had issues and mised up some columns. 
Sharing the information below incase it helps someone else.

I went into the CSV import code

Csv.Document(...) 

I changed the Quote Style to QuoteStyle.None and it fixed my issue
documetation
https://learn.microsoft.com/en-us/powerquery-m/csv-document

• QuoteStyle: Specifies how quoted line breaks are handled.
  • QuoteStyle.Csv (default): Quoted line breaks are treated as part of the data, not as the end of the current row.
  • QuoteStyle.None: All line breaks are treated as the end of the current row, even when they occur inside a quoted value.