Issue with long text load

[DenisSinai]

Hello,

I have csv file stored in sharepoind and I laod it to Power BI Desktop.

One of the filed is a text filed that include notes and it could be large, sometimes 10k characters.

When I load the file to power bi it splits the column with a large note to separate rows.

So for example if I have columns like this :

"Sales Person",   Customer,        Note

John Smith,      Alan Smith,       abs def ghig

power bit loads the data for that row as folowing:

"Sales Person",   Customer,        Note

John Smith,      Alan Smith,       abs 

def 

ghig

So, it splits the note by creatin addional rows and adding the next part of the note into the first column.

Any idea why it does that and how to fix it.

Thank you very much.

Denis.

[lbendlin · Accepted solution]

• 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.

Csv.Document - PowerQuery M | Microsoft Docs

[DenisSinai]

That helped. Thank you very much!