Forum Discussion
Multiple queries Joins in same table by using relationships
Can we join multiple queries in same table by using relationships? For example, I have query it returns last 10 days data, and I have separate query it returns last 20 days data….and then join both results in power bi into a single table … but I am not sure how exactly it works
4 Replies
- tctrout
Responsive Resident
I believe you are looking for the Append Queries feature. This feature allows you to combine the results from the 2 different queries, the apply de dupe steps if necessary.
https://docs.microsoft.com/en-us/power-query/append-queries - v-xiaotang
Community Support
Hi Mar2
This article describes it in detail, https://radacad.com/append-vs-merge-in-power-bi-and-power-query
hope it helps.
Best Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
- v-xiaotang
Community Support
Hi Mar2
Have you solved this problem? If yes, could you kindly accept the answer helpful as the solution (or kindly share your solution ). so the others can find it more quickly.
really appreciate!
Any question, please let me know. Looking forward to receiving your reply.
Best Regards,
Community Support Team _Tang - Mar2
Microsoft Employee
While append the queries in PBI getting below error
Expression.Error: Evaluation resulted in a stack overflow and cannot continue.
Note : - Here query 1 returns 120567 and query 2 return 150567 .While append queries in PBI getting the above error .