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 report. I know this is best suited for paginated reporting but the structure and visuals are all created and needed in Power BI and it is much easier to build an maintain there. I see that it is possible to generate an exported PDF using Power Automate and then I could possibly merge multiple PDFs from multiple reports. This seems a little clunky. Is there a good way to combine multiple data sets into one report? Thanks for any suggestions.