Forum Discussion
Exporting in multiple pages
- 8 months ago
Hi nish18_1990 ,
Thanks for reaching out to the Microsoft fabric community forum.
I would also take a moment to thank burakkaragoz , 123abc and ChielFaber , for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.
You’re right that Top N won’t work if your visual has no measure values. In that case, Power BI also doesn’t provide a built-in way to paginate table visuals automatically.
Paginated Reports, which are the only native option that truly supports page-by-page export. Power BI’s normal report pages capture only the visible area, so long tables will always export as a single slide with a scrollbar. Paginated Reports are designed for structured, multi-page layouts and will automatically split your table across multiple PPT slides. If you need clean, multi-page output for long tables, building a Paginated Report is the most reliable and recommended solution.Best Regards,
Community Support Team
Hi nish18_1990 ,
123abc and ChielFaber provided the best "Enterprise-grade" solution. The native "Export" feature essentially takes a screenshot of your visible screen. It does not scroll. Paginated Reports are the only tools designed to automatically "flow" content across pages.
However, if you need a quick workaround right now and don't have time to build a Paginated Report, you can use the "Manual Split" method:
Duplicate your report page in Power BI Desktop.
On Page 1, apply a "Top N" filter on the visual to show the top 10 items.
On Page 2, apply a filter to exclude those top 10 items (or show items 11-20).
When you export to PowerPoint, you will get two slides that essentially show your full list split across pages.
It is manual and not dynamic, but it solves the immediate problem without requiring a Premium license or learning Report Builder.
If this is a frequent requirement, definitely invest time in the Paginated Reports solution mentioned above.
If my response resolved your query, kindly mark it as the Accepted Solution to assist others. Additionally, I would be grateful for a 'Kudos' if you found my response helpful.
This response was assisted by AI for translation and formatting purposes.
Top N will not solve this issue as i dont have any measure values in the view. It has only 6 column fields from the data . Is there any option to idex or row number. Like give Row numbering starting from 1 and so on and then select them in filters .