Help passing parameters to paginated reports from Power BI

[MDMC]

Hi, 

I am trying to use a paginated report to create nicely formatted files to send information to our customers.  I need the user to be able to pass a parameter from the Power BI report into the paginated report to limit the amount of data loaded to a specific customer. 

I cannot find a good reference that demonstrates how to create the parameter within the Power BI report and how to pass it to the paginated report.  Does anyone have a training or video series they can recommend?

I'm very new at this so I more basic, the better!

Thanks!

[v-nmadadi-msft]

Hi @MDMC 

As we haven’t heard back from you, we wanted to kindly follow up to check if the suggestions  provided by the community members for the issue worked. Please feel free to contact us if you have any further questions.

Thanks and regards

[Poojara_D12]

Hi @MDMC 

Absolutely—you can pass a parameter (such as a CustomerID) from a Power BI report into a paginated report by defining a matching parameter in Report Builder, mapping it in your dataset query, and then embedding the paginated report in Power BI using the Paginated Report visual. In the visual’s settings, you assign values (from DAX measures or slicers) to the paginated report’s parameter. Alternatively, you can build a URL in Power BI (with rp: syntax) that launches the paginated report filtered accordingly. For a beginner-friendly walkthrough, start with Microsoft’s documentation on adding parameters in Report Builder and embedding the paginated visual in Power BI—then pair that with a YouTube tutorial showing the full flow from slicer to detailed export.

[v-nmadadi-msft]

Hi @MDMC ,

May I check if this issue has been resolved? If not, Please feel free to contact us if you have any further questions.

Thank you

[v-nmadadi-msft]

Hi @MDMC 

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.

Thank you.

[v-nmadadi-msft · Accepted solution]

Hi @MDMC ,
Thanks for reaching out to the Microsoft fabric community forum.
To pass parameters from power BI visual to paginated report
Switch on Toolbar from format pane

In the toolbar settings, switch on parameter as well

With this option enabled, you can select and apply parameters from the paginated report visual toolbar.

report visual toolbar.

Reference: Create and use the paginated report visual - Power BI | Microsoft Learn

I hope this information helps. Please do let us know if you have any further queries.
Thank you

[rohit1991]

Hi @MDMC ,

Here’s a simple, step-by-step way to pass parameters from Power BI to a paginated report:

1. Create the Parameter in Your Paginated Report: Open Report Builder and add a parameter (like CustomerID) to your report. Make sure this parameter is referenced in your query or filter logic.
   
   

2. Publish Your Paginated Report to Power BI Service: Upload your paginated report (RDL file) to your Power BI workspace.
   
   

3. Add the Paginated Report Visual in Your Power BI Report: In Power BI Desktop, insert the Paginated Report visual. In its settings, link it to your published paginated report from the service.
   
   

4. Bind the Parameter: In the visual’s settings pane, look for the “Parameters” section. Here, you can map a field or measure from your report (for example, a slicer or table selection) to the paginated report’s parameter (like CustomerID). This way, when the user makes a selection in the Power BI report, the same value is passed automatically to the paginated report.
   
   

If you prefer to launch a paginated report with parameters from a button or hyperlink, you can also create a custom URL using the report’s web address and append your parameter (e.g., ?CustomerID=123). This works for simple scenarios, but the visual method above gives you much tighter integration.

[pallavi_r]

Hi @MDMC ,

Please check this simple tutorials which might help.

https://www.youtube.com/watch?v=OQKgnJkjJDI

https://www.youtube.com/watch?v=NA66yUw1L4Q

If this post helps, please accept this as a solution. Appreciate your kudos.

Thanks,

Pallavi