Forum Discussion

Mar2's avatar
Mar2
Icon for Microsoft Employee rankMicrosoft Employee
5 years ago

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

  • v-xiaotang's avatar
    v-xiaotang
    Icon for Community Support rankCommunity 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's avatar
    Mar2
    Icon for Microsoft Employee rankMicrosoft 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 .