Powerbi export report pbix to PDF with a visual table, and this visual has scroll

[Anonymous]

I have a PBIX report which, when exported using C# client.GetPowerBIExportHelperAsync, has a page that displays a lot of information in a visual table. In the embedded report, the user can scroll down to see all the data due to table size, but when I export it, the table is not expanded and the rest of the data is not included. Moreover, in the document, on the page where the information is cut off, a scroll bar appears it seems a screenshot of the page. Is there any way to export the report so that all the information is visible? I saw if I export the file from powerbi workspace, I got the same result. I wonder if there's any workaround for this or fix.

Tech information:

Library used: Microsoft.PowerBI.Api v 4.20.0

Framework: net8.0

Lang: c#

[Anonymous]

Hi @Anonymous ,

Thanks lbendlin for the quick reply. I have some other thoughts to add:
The PDF only displays the page of the current scrollbar, which is due to the design.  You can create a paginated report in Power BI Report Builder and then export it to PDF or other formats. This should include all the data without truncation. Power BI Paginated Reports are designed for printing and PDF generation, and they handle large tables better. 

For more details, please refer: Export Power BI paginated reports - Power BI | Microsoft Learn

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly. 

[Anonymous]

Thank you all for you quick response,

Well actually we are currently working on finding a solution or workaround to export the full content of a table in a PBIX report to a PDF file. While exploring the documentation, I haven't found a clear answer beyond either expanding the report's page size or using RDL files. However, I believe RDL files may limit users to fewer visuals, such as charts.

I believe expanding the report’s page size could lead to undesirable behavior, since the report contains dynamic data, there could be scenarios where increasing the page size does not fully accommodate the number of records, or it results in an excessively large embedded report that is not user-friendly.

We are seeking a more flexible approach that ensures all data is included in the export while maintaining usability.

[lbendlin]

You have exactly two options

- reduce the amount of data so the visual doesn't have scrollbars

- abandon the idea of exporting to PDF

[lbendlin]

Is there any way to export the report so that all the information is visible? 

Only if you make the table contents fit on the page. There is nothing you can do when your visual has scrollbars.