Hi, @Anonymous
First, make sure that the data source is compatible with paginated reports. If you're combining data from multiple sources, consider developing a data model with Power BI Desktop, as it allows for efficient data composition and transformation. For more information, check the following link:
Data retrieval guidance for paginated reports - Power BI | Microsoft Learn
When designing paginated reports in Power BI Report Builder, understand that each report will represent a separate tab in your Excel workbook. Take advantage of the Excel Rendering Add-in to ensure that your reports are optimized for Excel output. For more information about exporting a report to Excel, you can check the following link:
Export Power BI paginated report to Microsoft Excel (Power BI Report Builder) - Power BI | Microsoft Learn
Currently, exporting multiple paginated reports directly to a single tab in a single Excel workbook is not a built-in feature. However, you can do this by exporting each report individually and then manually combining them into a single workbook, or by using scripts or third-party tools to automate the process.
How to Get Your Question Answered Quickly
Best Regards
Yongkang Hua
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
