Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Solved! Go to Solution.
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
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
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
88 | |
63 |