Hello Abd,
I am afraid to say that creating 100 data set from 100 tables from the same database may not be appropriate or sustainable. Even if you dislike it you may need to join the tables to get a data set where you could create topic for Q&A.
Some reference link -Joining data - Amazon QuickSight
Modeling - Two fact tables and different level
https://aws.amazon.com/blogs/big-data/dimensional-modeling-in-amazon-redshift/https://community.amazonquicksight.com/t/2-fact-tables-in-one-dataset/17545
Hope this helps.
Cheers,
Deep