Forum Discussion
Solved
Issue with long text load
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.
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.
2 Replies
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.
That helped. Thank you very much!
