Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Button for Exporting a PDF from a Paginated Visual

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.

  • 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.

2 Replies

  • ajohnso2's avatar
    ajohnso2
    Solution Supplier

    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.

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi Anonymous ,

     

    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.