Button for Exporting a PDF from a Paginated Visual

[gaboya]

Hello,

My Power BI report consists of a slicer on page 1 and a paginated report visual on page 2, which is affected by the slicer. How can I create a button on page 1 which will download the content of the paginated report visual on page 2 as a PDF file? (I know that there is an export as pdf button on the paginated visual, but I need such export as pdf button on page 1 instead.)

Thank you in advance.

[ajohnso2 · Accepted solution]

Perhaps not exactly what you are after but this will export to pdf (after rendering the report).

https://app.powerbi.com/groups/{WORKSPACE ID}/rdlreports/{REPORT ID}?ctid={CTID}&rp:pIncomingCostCentre=06719&rdl:format=PDF&experience=power-bi

Replace {}, you can get this info by checking the url when your paginated report is rendered in a browser.

You can pass any parameter values you need within the URL using &rp:<parameter name>=<parameter value>

&rdl:format=PDF is where you define what format (you can also export to excel etc).

Drop a blank button into your desktop report and set the action to URL - you can add the url to a measure and make the parameter values dynamic from here.

If you have on prem report server there is a much nicer way of achieving this outcome.

[v-kongfanf-msft]

Hi @gaboya ,

To create a button on page 1 of your Power BI report that will download the content of the paginated report visual on page 2 as a PDF, you can use Power Automate along with Power BI.

You can refer to below document:

Export and email a report with Power Automate - Power BI | Microsoft Learn

Best Regards,
Adamk Kong

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