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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
MDMC
Frequent Visitor

Help passing parameters to paginated reports from Power BI

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!

7 REPLIES 7
v-nmadadi-msft
Community Support
Community Support

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
Super User
Super User

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.

 

Did I answer your question? Mark my post as a solution, this will help others!
If my response(s) assisted you in any way, don't forget to drop me a "Kudos"

Kind Regards,
Poojara - Proud to be a Super User
Data Analyst | MSBI Developer | Power BI Consultant
Consider Subscribing my YouTube for Beginners/Advance Concepts: https://youtube.com/@biconcepts?si=04iw9SYI2HN80HKS
v-nmadadi-msft
Community Support
Community Support

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

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

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

vnmadadimsft_0-1752835878578.png

In the toolbar settings, switch on parameter as well

vnmadadimsft_1-1752835888785.png

 

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

report visual toolbar.

vnmadadimsft_2-1752835898962.png

 

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
Super User
Super User

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.

 


Did it work? ✔ Give a Kudo • Mark as Solution – help others too!
pallavi_r
Super User
Super User

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

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.