Power Bi Report Builder: Pull data from related table?

[olimilo]

I understand relationships aren't imported by PBI Report Builder so I'm asking, is there some way I can pull the data from two separate tables if my tables look like the one below (1:M relationship).

For example, if I select John Doe's data, how can I get his relevant data from the 2nd table into my table visual in report builder?

[Anonymous]

@olimilo 

Try merge the two tables with fullouter joint with Emp Id, so you can have 1 data table only.

Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[olimilo]

@Anonymous This isn't a possible solution on our end as a report is using the dataset and duplicating the queries would blow up the dashboard. We ended up adding an EmployeeName field on the second table that will act as the filtered field when the user selects an employee during report runtime.

I hope MS provides a much better solution for this if they really want PBI Report Builder to make use of PBI datasets.

[amitchandak]

@olimilo , if join Emp ID in both tables. Then filter of table 1 should pass 2 table2?

[olimilo]

Hi @amitchandak 

I'm sorry but I'm not getting your suggestion. There's no way to manage relationships in the Power BI Report Builder. Can you expound further?

Edit: I forgot to mention, I'm using a Power BI dataset.