Thanks @Phil_Seamark,
I may not have explained what I need very well. It is kind of the opposite of what you suggest. I want to have multiple PBIX file all pointing to the one data source, being one already created and published to the service with imported data from SQL. Now ideally I would do all this in the one PBIX, but you can only have one report, and if you have more than 15 pages, export to PowerPoint won't work, and as you say scrolling becomes a pain.
I know SSAS on prem is one option, but we spent ages previously doing this and found the performance dismal. With the model in the service, performance us much better, but I would like to only have the one model, and a number of different reports using it.
I know I can create the reports directly in the service, but then they don't respond well to model changes, they just fail if they depend on a measure that has changed name, whereas reports in the PBIX file see changes to the model and adapt. I also understand that if we were able to use more than one PBIX file pointing to the same model the second and subsequent ones would not adjust to changes in the model, but at least we could divide up the reports and publish them with some form of version control.
All said, I am looking at ways to improve the development life cycle of Power BI based reporting, but am struggling to setup something that is not fragile or overly painful to manage.
