How to display full data of the tables when exporting Power BI report as PDF?

[PatrickGreen]

Hi! 

I noticed that whenever I am trying to export a Power BI report as PDF through an email subscription, the table's contents are being truncated depending on the visual size. I am working on a general client report where the table could be a long list of data which would generally require a scroll bar. 

Can I do this in Power BI and have a full table (not truncated) when exporting as PDF? Or do I need to explore other Microsoft Fabric alternatives, e.g. like paginated reports, though I am not sure as we also need to display charts and visuals (and not just tables) in the PDF report.

[v-priyankata]

Hi @PatrickGreen 

Thank you for reaching out to the Microsoft Fabric Forum Community.

@cengizhanarslan @MFelix @tayloramy  Thanks for the inputs.

The information provided by users was helpful. please try those, If you still have questions, please don't hesitate to reach out to the community.

[v-priyankata]

Hi @PatrickGreen 

Hope everything’s going smoothly on your end. I wanted to check if the issue got sorted. if you have any other issues please reach community.

[PatrickGreen]

Hi all! Will the paginated report also enable visuals (like line charts from underlying data) to be printed in the report as PDF? I have been trying to look for that option in Power BI service, but I cannot find any unfortunately.

[tayloramy]

Hi @PatrickGreen, 

THe visualization options in paginated reports are a lot more limited than in Power BI reports, but if you can build it in the paginated report then yes, it will print as intended. Pagianted reports are designed to be printed. 

If you found this helpful, consider giving some Kudos. If I answered your question or solved your problem, mark this post as the solution.

[tayloramy]

Hi @PatrickGreen, 

A paginated report would be the way to go for this. Paginated reports are designed to be printed (or saved as a PDF) where Power BI reports are designed to be interactive. 

Paginated reports can print the entire dataset to PDF. 

If you found this helpful, consider giving some Kudos. If I answered your question or solved your problem, mark this post as the solution. 

[MFelix]

Hi @PatrickGreen ,

The export to PDF from a power BI report will always only show what is visible on the page, for this type of need that you have a table that needs to have all the information I suggest that you use the Power BI Paginated reports this will allow you to generate a pdf in a report manor that will allow for multiple pages of a table.

https://learn.microsoft.com/en-us/power-bi/paginated-reports/paginated-reports-report-builder-power-...

[cengizhanarslan]

Unfortunately, no — standard Power BI reports cannot export a long, scrollable table in full using Email Subscriptions or Export to PDF.

This is a fundamental limitation of the Power BI report rendering engine, which uses a fixed-layout canvas. During PDF export, only the visible portion of a visual is rendered; visuals do not expand dynamically, so any content requiring scrolling is truncated.

To achieve a fully expanded table across multiple PDF pages, you must use a Paginated Report instead of a standard Power BI report.

Unlike Power BI reports, Paginated Reports support:

• Dynamic page length

• True pagination

• Pixel-perfect layout

• Multi-page tables with repeating headers

• Email subscriptions with complete, non-truncated data