Forum Discussion
Anonymous
6 years agoNot applicable
CSV cell character length truncated when importing
Hello
I imported a CSV and one column, who's cells can contain 100s of characters seems to be truncated to 200 characters when importing. I checked the CSV and all the data is there, but not in PBI
Any Ideas?
Thanks
- Anonymous6 years ago
I just realised that I loaded an Excel file and not a CSV. It's working now.
Thanks for the link
2 Replies
- amitchandak
Super User
Anonymous , refer if this can help
https://blog.crossjoin.co.uk/2019/05/17/maximum-length-text-value-power-bi/
- AnonymousNot applicable
I just realised that I loaded an Excel file and not a CSV. It's working now.
Thanks for the link