QuickSight new dataset preparation experience breaks multiline CSV fields (newlines within quotes treated as new records)

Hi,

I’ve recently run into an issue with Amazon Quick Suite after the new dataset preparation experience was rolled out.

In the legacy dataset prep screen, CSV files that contained newline characters inside quoted fields (for example, text fields with line breaks) were handled correctly — meaning the newlines stayed within the same record.

However, in the new dataset preparation interface, it now seems to split each newline within double quotes into a new record, which completely breaks the structure of multiline data. This looks like a bug. Can someone please provide support and whether this can be fixed?

Here are screenshots for better understanding:

Hi @shubhamkumar.iitk712 and welcome to the Quick Suite Community!
Thank you for bringing this to attention; I would suggest creating a support ticket to get this on file. To my understanding, some additional features are still being brought in to the new data prep experience, and in the interim, you can continue to utilize the legacy version as to avoid these errors/issues!

cc: @vignessh.b

2 Likes

Hi @Brett , Thank you for the response! I’m currently on the Basic Support plan, so I don’t have the ability to create a technical support ticket. Would it be possible for this issue to be internally forwarded to the QuickSight team?

In the meantime, I’ll continue using the legacy dataset experience. I was really looking forward to the new features in the updated interface and meaning to utilize it, so I hope this issue get resolved soon (as most of our datasets are csv based).

Hi @shubhamkumar.iitk712,
I am not an AWS employee so I would not have the ability to raise internally, however I did tag someone from the team that will review this.

@shubhamkumar.iitk712 (cc: @Brett ) This issue has now been addressed in the new experience. Screenshot below replicating your sample data in the new experience. Can you try now and confirm it addresses your use case?

1 Like