Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
Mar2
Employee
Employee

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 4
Mar2
Employee
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 .

v-xiaotang
Community Support
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

v-xiaotang
Community Support
Community Support

Hi @Mar2 

vxiaotang_0-1629967387527.png

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
Resolver III
Resolver III

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

 

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors
Top Kudoed Authors