How to split a macro report into subreports without redundant dataset?

Good morning

I have a report with more than 20 pages, which uses a SQL Server with mixed storage mode (Imported and DirectQuery) and I would like to get 3 subreports each with a range of pages of the macro report and accessing the same database and tables (there are more than 20).

Upload the 3 sub-reports generates 3 datasets in the Service

As there are imported tables I assume that there will be redundant data, but I would prefer to have a single set of data instead of 3, since in addition the 3 would have to be automatically updated daily.

I thought that after uploading the first subreport (I already have a dataset), you could change the data source of each of the tables to use the dataset of the first subreport (dynamic connection) but this would involve doing it in 20x2 = about 40 tables. I don't see how to replace the general SQL Server source with the dataset for all tables at once.

I only need the 3 sub-reports and the unique dataset in Service, in Desktop with the macro report would suffice.

Some idea or suggestion to get it.

Thanks a lot!!!!