The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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
Solved! Go to 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.
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.
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.
Hi @v-sgandrathi , I just saw the response from @GilbertQ I will go through that link.
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.