Combine/union multiple datasets in Report Builder

[Fej]

Hello everyone.

We were tasked to create Paginated Reports using Report Builder and the task involves using union on the multiple datasets to create a report table. We're fairly new to the Report builder so there's a lot of things we don't know yet. The datasets were created by SQL scripts that were given to us and are already in the report builder, we just need to use union on it. Is there a way to do this in the platform?

We're also using ODBC connection to connect to Snowflake on AWS for this task.

Thank you!