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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
JK800
Frequent Visitor

Pass Main Report Parameters to Nested Sub-Report

Hi,

 

I am using PowerBI Report Buidler to build a paginated report. Is there a way to pass main report parameters to a sub-report that is nested within another sub-report? Trying to do this but it is causing errors in the first sub-report.

 

Thanks

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hi @JK800 ,

Let’s break down the steps to achieve this:

  1. Create the Reports:

    • First, create the main report and the subreport(s) you want to nest within it.
    • Save both reports to the same Power BI workspace.
  2. Design the Parent Report:

    • Open the main report in Power BI Report Builder.
    • In the Design view, right-click the subreport placeholder where you want to embed the subreport.
    • Click Subreport Properties.
  3. Specify Parameters for the Subreport:

    • In the Subreport Properties dialog box, navigate to the Parameters section.
    • Click Add to create a new parameter row in the grid.
    • In the Name text box, type the name of a parameter in the subreport or choose it from the list box.
    • Repeat this step for any other parameters you want to pass.
  4. Link Parameters:

    • Now, go to the Subreport Links window.
    • Search for your parameters on the left side and move them to the right side.
    • Ensure that the option for Select data in subreport based on field is unchecked for these parameters.
    • Click OK to save the changes.
  5. Open the Subreport:

    • Finally, open the subreport itself and ensure that it handles the parameters correctly.

Below is the official link will help you:
Pass a report parameter within a URL for a Power BI paginated report - Power BI | Microsoft Learn

Add a subreport and parameters to a Power BI paginated report - Power BI | Microsoft Learn

Best Regards,

Xianda Tang

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

View solution in original post

1 REPLY 1
Anonymous
Not applicable

Hi @JK800 ,

Let’s break down the steps to achieve this:

  1. Create the Reports:

    • First, create the main report and the subreport(s) you want to nest within it.
    • Save both reports to the same Power BI workspace.
  2. Design the Parent Report:

    • Open the main report in Power BI Report Builder.
    • In the Design view, right-click the subreport placeholder where you want to embed the subreport.
    • Click Subreport Properties.
  3. Specify Parameters for the Subreport:

    • In the Subreport Properties dialog box, navigate to the Parameters section.
    • Click Add to create a new parameter row in the grid.
    • In the Name text box, type the name of a parameter in the subreport or choose it from the list box.
    • Repeat this step for any other parameters you want to pass.
  4. Link Parameters:

    • Now, go to the Subreport Links window.
    • Search for your parameters on the left side and move them to the right side.
    • Ensure that the option for Select data in subreport based on field is unchecked for these parameters.
    • Click OK to save the changes.
  5. Open the Subreport:

    • Finally, open the subreport itself and ensure that it handles the parameters correctly.

Below is the official link will help you:
Pass a report parameter within a URL for a Power BI paginated report - Power BI | Microsoft Learn

Add a subreport and parameters to a Power BI paginated report - Power BI | Microsoft Learn

Best Regards,

Xianda Tang

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!

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Feb2025 NL Carousel

Fabric Community Update - February 2025

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

Top Kudoed Authors