Multiple queries Joins in same table by using relationships

[Mar2]

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

[Mar2]

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 .

[v-xiaotang]

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

[v-xiaotang]

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.

[tctrout]

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