I am loading CSV file in Power Query editor (Excel desktop). The CSV file has 4 columns. Column 4 has text that is getting truncated when previewing the data in Power Query editor.

Any help or suggestions??

I tried reading some references. But nothing that clicked for me.

References

Chris Webb's BI Blog: What Is The Maximum Length Of A Text Value In Power BI? Chris Webb's BI Blog

CodePudding user response：

The text is not being truncated -- only the display in the lower window is truncated, as noted by the ellipsis at the end.

You can prove this in several ways.

• LEN(original text) with the leading and trailing double quotes removed; and the doubled-double quotes replaced by single-double quotes will have the same length as Text.Length([Audit Data])
• Enter a custom column with something like =Text.End([Audit Data],150) and you'll see what you are missing in the preview at the bottom of the page.
• Split [Audit Data] by a fixed number (eg 1000) and you'll see the entire string in the different columns.
• Load the data table to an Excel worksheet and you will see that no text has been lost