Forum Discussion
Helper ILink three tables by the unique key from Oracle database
Hi all,
I'm trying to create a full data report by Paginated Report (SSRS).
First, I connect the Oracle database to the desktop creating the layout, then publish it to the online service. The relationship among these three tables can be built automatically by the desktop. For example, when I filter by the order number, it will affect all three tables.
Second, I add the Power BI dataset which I published to the online service to Paginated reports (SSRS). But The relationships in the Power BI model do not follow through to the Paginated report, i.e., a data model is not created within Report Builder. When I choose the order number, it can only affect 1 table, the other two tables will not be linked.
Third, because of the way I set it up, I've tried the SQL using the unique key to connect three tables but it didn't work out.
Please feel free to let me know if you have any thoughts.
Best Regards,
Tiffany
Try connect both the oracle and the additional dataset in Desktop, publish to service after you manage the relationship between tables. Then use SSRS to add this power bi dataset as the source.
Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.
3 Replies
- amitchandak
Super User
TiffanyCui , Can you share the data model, Also check was filters working the way you wanted on power by desktop?
TiffanyCuiHi Amit,
Thank you for reaching out. Unfortunately, I cannot share the data model. And, the filters I wanted is not by the desktop. For example, I just drag "work order" as a filter on this page, all the tables will be filtered automatically by desktop. What I need to do is to build this filter relationship through Paginated reports. The relationships in the Power BI model do not follow through to the Paginated report, i.e., a data model is not created within Report Builder. I will post this help to other forums to see if anyone is familiar with paginated reports (SSRS).
Thank you for your patience and time.
Try connect both the oracle and the additional dataset in Desktop, publish to service after you manage the relationship between tables. Then use SSRS to add this power bi dataset as the source.
Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.
