Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Report Builder Value passing

Hi,

 

I have two data sets and built paginated reports in report builder.

 

Data set 1: Name, Destination, Value, qty

 

Data set 2: First Name, Last Name, Qty, Sales.

 

Both data sets doesn't have a common column.

 

Question 1: Can we built report 1 and report 2 in report builder as pages like the way what we do in Power BI desktop?

 

Question 2: I want to pass selected value from report 1 to report 2 like if I selct Qty the selected value should pass to the second report. Is it possible if there is no common column from both the reports and both are from different data sets?

 

If yes, not sure how to implement in report builder, any link please appreciated your support.

 

Thanks,

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    No Amit, that is not what I am looking for. 

  • Anonymous's avatar
    Anonymous
    Not applicable

    HI,

    Perhaps you can design and publish the PBIX file to the power bi service with your dataset tables and relationship.
    Then you can connect to the dataset from the Report Builder.

    This dataset will include all relationships built in the data model and they should help you interact between different data tables without pass/receive parameters.

    Regards,

    Xiaoxin Sheng

  • Anonymous's avatar
    Anonymous
    Not applicable

    Experts,

     

    any help in this regards.

     

    Thanks,