Hi @smithaa ,
welcome to the community 
What you need is a union-option in QuickSight to union all 7 tables into one, but QuickSight does not offer it at the moment.
As you mentioned you get the 7 datasets from an asset table, could you use a custom sql to union the 7 tables into one table?
Here you can find a step-for-step instruction:
As alternative you can use Glue to union the data an write it into a single table.
In case both option do not work, maybe this blog post can be helpful:
If this helped you, please mark my answer as solution. That helpes the community to find solutions faster.
Best regards,
Nico