Forum Discussion
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
- amitchandak
Super User
Anonymous , refer if this video from guyinacube can help
- AnonymousNot applicable
No Amit, that is not what I am looking for.
- AnonymousNot 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
- AnonymousNot applicable
Experts,
any help in this regards.
Thanks,