currently hitting the dataset limit which is around 50 different data sets in quicksight what is the best solution to resolve this issue ? is it better to just create another separate dashboard in quick sight to resolve this issue ?
Hi @izzycs
Are you refering to the limit in terms of how many datasets can be included in an analysis? Per my understanding an analysis can have at most 30 datasets which most likely should be more than enough.
So, can you elaborate on what is the actual issue so we can comment/provide feedback?
Regards,
Giri
Hi @izzycs ,
Quick thing on the number first, because it changes how you think about this: it’s actually 50 datasets per analysis on Enterprise now, not 30. The 30 still shows up in some of the older AWS troubleshooting pages, but the current Adding visuals doc says 50 ( Adding visuals to Quick Sight analyses - Amazon Quick ), and that matches you hitting the wall right around 50. So you’re not misreading it, you really are at the ceiling.
As for what to do about it, a second dashboard is a totally fine way to go if the stuff splits up naturally into separate areas, and honestly it’ll probably load quicker that way too. But before you go cloning dashboards, I’d recommend taking a look at whether you can just trim the dataset count down. If your data’s coming from a database, or Athena or Redshift, pushing those joins into custom SQL (or a view) so one dataset does the job of several keeps it all in a single analysis, and it’s usually the tidier fix.
Hi @izzycs,
Just checking back in since this thread hasn’t received a response in a while. Was Jacob’s reply helpful to you and/or were you able to find a solution yourself in the meantime? Please help the community by marking this answer as “Solution” or following up in general within the next 3 business days!
Thank you!
Hi @izzycs ,
Since I haven’t received any further updates from you, I’ll treat this inquiry as complete for now. If you have any additional questions, feel free to create a new post in the community and link this discussion for context.
Thank you