Quicksight Dataset Preview Error

When previewing a dataset we are getting the following error:

Your data can’t be prepared because of a recent change. To isolate the cause of this issue, first check your most recent changes, and then check external factors that involve connecting to your data.

This does not appear to impact the import or the usage but we are unable to see the data.
the dataset is using a Mysql RDS database and includes a join and utilizes spice.

Anyone have this?

Hi,

You can troubleshoot it by using a simple table to import. This step will verify your connection with MYSql. if it good to go, secondly you can run your query on database and verify the result is working fine.

You can create view if you are using some complex query.

Create a new dataset and try your data.

Hope these steps will solve your problem.

Regards
Naveed Ali

Hi @Jim,
It’s been a little while since we last heard from you. Just checking in to see if Naveed’s response was helpful for the problem you were encountering? If you’re still having issues, let us know what other types of tests you’ve done to work on this in the meantime.

If we do not hear back within the next 3 business days, I’ll go ahead and mark solution but if you have any questions past that; feel free to create a new topic for discussion and link this discussion for relevant information.

Thank you!

Hi @Jim,
Since we haven’t heard back from you, I’ll go ahead and mark as solved but if you have any additional questions, feel free to create a new topic for discussion.

Thank you!