Forum Discussion
Combine Multiple Matrix Visualisations from Separate Tabs into One Long Printable Page (A4) in Power
- 10 months ago
Hi SachinC ,
Thanks for reaching out to Microsoft Fabric Community and thanks for the follow-up.
Using Power Automate, you can export multiple report pages as separate PDFs and then merge them into a single file, but this won’t create a continuous scrolling layout - it will just combine the exported pages.
If your requirement is to build a single printable layout that stacks all matrices, a Paginated Report would be the suitable option. It supports pixel-perfect layouts, allows direct connection to your existing Power BI dataset (including DAX measures), and provides control over how each matrix or section appears across pages. You would need to recreate the visuals in Report Builder using the same dataset, as Power BI visuals cannot be directly imported.
For reference, you can check the following community discussions and documentation that explain similar scenarios and design approaches:
Paginated Report in Report Builder Power BI - Microsoft Fabric Community
Solved: Re: How to create a paginated report of multi-page... - Microsoft Fabric Community
Multiple Tabs in Power Bi Paginated Reports - Microsoft Fabric CommunityCreate a paginated report based on a Power BI shared dataset - Power BI | Microsoft Learn
These threads provide examples of how users have handled multi-page or multi-matrix layouts using paginated reports.
Hope this helps clarify your next steps. Please reach out for further assistance.
Thank you.
-
Is there any way to combine multiple report tabs into one printable/scrollable layout in Power BI Desktop or Service?
- The best suitable would probably be Paginated reports visual (basically embedding a paginated report to Power bi. -
Would Paginated Reports be the recommended approach here — given I already have DAX measures and SQL-based datasets in my Power BI model?
- Yes, it would be recommended. You can use the dataset from power bi (including dax measures). -
If yes, what’s the best way to replicate the look and feel of my existing Power BI matrices in Report Builder using the same dataset?
- You will have to start from scratch unfortunately (to build the reports) I think. -
Any known techniques, community examples, or best practices for turning multi-tab matrix reports into one stacked printable summary?
- it all depends on the case of use. I would say look at online tutorials and pick what suits you the best.