Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
Anonymous
Not applicable

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.

1 ACCEPTED SOLUTION
ajohnso2
Super User
Super User

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.

View solution in original post

2 REPLIES 2
ajohnso2
Super User
Super User

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
Community Support
Community Support

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.

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.