Forum Discussion
Export Power BI Report Page using Fabric Notebook
Hello Community,
Is there a way to export a Power BI report page to PDF using Notebook while including all data contained within visuals that have scroll bar?
I have Fabric Capacity and need to export a Power BI page to PDF while preserving the existing page layout and visual formatting. I can use Subscriptions, but the exported PDF only captures a snapshot of the data currently visible on the page.
Some of my visuals contain vertical scroll bar, and any data that requires scrolling is not included in the PDF export.
Has anyone found a way to export the full visual content, including the data beyond the visible scroll area, while retaining the report's formatting and layout using Notebook ?
Short answer
No, there isn't a way to do this via a notebook (or any other automation) that gets around the limitation, it's documented, by-design behavior of the Power BI report rendering engine itself, and that engine is what both the UI export and the REST API (which is what a notebook would call) use. See the link bellow
Export Power BI reports to PDF limitations
What could solve it (Native options)
- Paginated Reports (RDL / Report Builder), they repaginate large tables across multiple PDF pages instead of clipping them in a scroll region, and they don't share the 50-page/scrollbar limitations of interactive reports. Trade-off: you rebuild the table/matrix as a paginated report item rather than reusing your existing interactive-report visual as-is, so layout/formatting needs to be recreated in Report Builder (it won't automatically mirror your Power BI page's exact visual).
- Exportable Formatted Data Tables (Preview), a newer, no-Report-Builder-needed option: from the Power BI service you can build a full-data table directly off your semantic model (sortable, stylable, with headers/footers/images) and export it to PDF/PPT/Excel "with full formatting fidelity," with none of the scrollbar/50,000-row CSV type limits. Caveat: it produces its own standalone table-report object.
Did I answer your question, please mark the post as a solution or consider a like.
5 Replies
- AvdBerg
Resolver II
Short answer
No, there isn't a way to do this via a notebook (or any other automation) that gets around the limitation, it's documented, by-design behavior of the Power BI report rendering engine itself, and that engine is what both the UI export and the REST API (which is what a notebook would call) use. See the link bellow
Export Power BI reports to PDF limitations
What could solve it (Native options)
- Paginated Reports (RDL / Report Builder), they repaginate large tables across multiple PDF pages instead of clipping them in a scroll region, and they don't share the 50-page/scrollbar limitations of interactive reports. Trade-off: you rebuild the table/matrix as a paginated report item rather than reusing your existing interactive-report visual as-is, so layout/formatting needs to be recreated in Report Builder (it won't automatically mirror your Power BI page's exact visual).
- Exportable Formatted Data Tables (Preview), a newer, no-Report-Builder-needed option: from the Power BI service you can build a full-data table directly off your semantic model (sortable, stylable, with headers/footers/images) and export it to PDF/PPT/Excel "with full formatting fidelity," with none of the scrollbar/50,000-row CSV type limits. Caveat: it produces its own standalone table-report object.
Did I answer your question, please mark the post as a solution or consider a like.
AnmoldeepHelper I
Hi,
No, it is not possible with notebooks you can try Paginated Reports.
Rebuild the detail-heavy visuals as a paginated report (.rdl) in Power BI Report Builder against the same semantic model, and embed it via the Paginated Report visual on your page.
jubinsoniMemorable Member
Hi Nirav_Synapx, if you specifically want to stay in a notebook, one option is to split the job in two. Use semantic link in the notebook to run a DAX query against the same semantic model and get the full table, then build the PDF yourself from that data with a library such as reportlab, so nothing is cut off by a scroll area. You lose the exact page look, so it fits best for the detail tables only. A lighter option is to give the heavy visual its own tall report page with the visual sized to fit its rows, then export that page, since the export captures what the page renders.
v-achippaCommunity Support
Hi Nirav_Synapx,
Thank you for reaching out to Microsoft Fabric Community.
Thank you AvdBerg, Anmoldeep and jubinsoni for the prompt response.
As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by the users for the issue worked? or let us know if you need any further assistance.
Thanks and regards,
Anjan Kumar Chippa- v-achippa
Hi Nirav_Synapx,
We wanted to kindly follow up to check if the solution provided by the users for the issue worked? or let us know if you need any further assistance.
Thanks and regards,
Anjan Kumar Chippa