Importat an CSV files to Power BI

[GharbiamalBI]

Hello everyone, I imported a csv file from kaggle to power BI, except there are cells left with commas.

[jcalheir · Accepted solution]

Would you care to share kaggle csv file?

[OliT · Accepted solution]

Hi @GharbiamalBI 

>> except there are cells left with commas.

My suggestion is to split these lines separately. There is a function of splitting by punctuation in power query. After they are split, then merge them with other lines.

Regards,

OliT

[jcalheir · Accepted solution]

Would you care to share kaggle csv file?