Relationships in Query Editor

[Gopa]

Hi

Is it possible to create relationships between tables in Power Query Editor? For example there is a header table and a line item table and I want to filter out records in the line item table which has a certain property in the header table. I was checking if this can be achieved in query editor itself before loading it to the data model and use DAX to filter out.

I understand relationship creation is not possible in query editor. So, is there any other way we can do this?

[Thejeswar · Accepted solution]

@Gopa,

Yes there is something called Merge Queries.

This is similar to join. You will have to define the join condition between the tables. After the tables are joined, you can filter the data on the column of your need and "Close and apply" the changes to load the data to the report

Regards,.

Thejeswar

[Gopa]

@Thejeswar

Thank you very much. Solved the issue...instead of bringing in all the columns, brought only the relevant column from the header table to the line item table and added the filter to that column in the line item table. Thank you once again for the pormpt response. 

[Thejeswar]

@Gopa

Welcome