Paginated Power BI Reports export to excel with multiple tabs

[Anusha__v]

Hi,
In Paginated Power BI Reports export to Excel with multiple tabs. Through Region Groups we can add the page break option and export.

However, I require the data to be the same in the two tabs. 
For example, in sheet one I have sales data in Sheet 2 its units

Please let me know how can we handle this senario's in one Paginated Power BI Report.
Thanks

[v-sgandrathi]

Hello @Anusha__v,

Thanks for reaching out to the Microsoft Fabric Community forum.

Thank you @GilbertQfor your prompt response. Your input is likely to be quite helpful in addressing the query.

In Power BI Paginated Reports, use two Tablix: one for Sales data and another for Units data.

Set page breaks between them and assign PageName properties ('Sales' for Sheet 1, 'Units' for Sheet 2).

This ensures each dataset appears on separate sheets with proper naming when exported to Excel.

I hope this clarifies your issue. If this post was helpful, please consider marking Accept as solution to assist other members in finding it more easily.

If you continue to face issues, feel free to reach out to us for further assistance!

Regards,
Sahasra.

[Anusha__v]

Hi @v-sgandrathi ,
Thanks for your Response. I am using Rectangle as a container. And Adding a Page Break.
But can you explain more details on this point "assign PageName properties ('Sales' for Sheet 1, 'Units' for Sheet 2)" any image I am not able to get this option.
Thanks for your help.

[Anusha__v]

Hi @v-sgandrathi , I just saw the response from @GilbertQ I will go through that link.

[GilbertQ · Accepted solution]

Hi @Anusha__v 

A quick tip if you are ever looking for solutions with paginated reports. Search for SSRS or sql server reporting services, as this is what paginated reports were called before. With that being said, there is a way to get the data in multiple sheets.

Exporting SSRS reports to multiple worksheets in Excel