Forum Discussion
Creating one report from Multiple data sets
I need to determine the best way to create and print a single report that includes visuals from multiple reports each with a separate data source so my users can select a give client and create one r...
If you are using the Power BI cloud service you could try using this feature Using DirectQuery for datasets and Analysis Services (preview) - Power BI | Microsoft Learn to create one dataset that combines all your other datasets, then build a single report off that.
Unfortunately this feature is not supported in the on-prem Report Server and paginated reports would be the only option there.