Presence of a delimiter (comma) in a few values create a mess

[adrien5555]

Hello all,

My data sources are mainly CSV files, whose delimiter is a "comma"

If ever there are commas within the values, it creates a mess, as every value is then offset:

Surely, there is an easy way to fix this in PBI?

Many thanks,

[asocorro]

This would be a problem with any tool.  The comma is overloaded.  If possible, ask for TAB-delimited files, for example.

[adrien5555]

Ok, but rather than having to edit this CSV in excel, isn't it possible to edit it right from PBI?