Forum Discussion

Gopa's avatar
Gopa
Advocate II
8 years ago
Solved

Relationships in Query Editor

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 w...
Need Help
  • Thejeswar's avatar
    Thejeswar
    8 years ago

    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

Thejeswar's avatar
Thejeswar
Super User
8 years ago

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's avatar
    Gopa
    Advocate II
    8 years ago

    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.