CSV cell character length truncated when importing

[Anonymous]

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

[amitchandak]

@Anonymous , refer if this can help

https://blog.crossjoin.co.uk/2019/05/17/maximum-length-text-value-power-bi/

[Anonymous · Accepted solution]

I just realised that I loaded an Excel file and not a CSV. It's working now.

Thanks for the link