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

[Syndicate_Admin]

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!!!!

[AlexisOlson]

Can you clarify what you mean by "subreport"? This usually makes me think of Paginated Reports (.rdl) rather than Power BI Destkop (.pbix) but paginated reports don't have the same Import/DirectQuery distinction.

[Syndicate_Admin]

The main report has 22 pages, you want 3 reports that include subsets of these same pages with all their visualizations. Nothing to do with paginated reports.

Greetings and thanks

[AlexisOlson]

You can connect the subreports to the existing "macro report" dataset rather than creating new datasets for each one.

See the documentation here:
https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-report-lifecycle-datasets