Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi All,
I am using Power query in PowerBI and I want to combine two tables that have the same columns into 1 query with no duplicates.
Example:
Table 2
The result should be like this:
How can I do this? thank you!
Solved! Go to Solution.
Hello @Anonymous ,
this can be done in Power query using Appending queries.
check this video https://youtu.be/xl2Cc8XugHU?si=iZdDQleMUFAmPf6N
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Follow me on Linkedin
Vote for my Community Mobile App Idea 💡
Proud to be a Super User! | |
Hello @Anonymous ,
this can be done in Power query using Appending queries.
check this video https://youtu.be/xl2Cc8XugHU?si=iZdDQleMUFAmPf6N
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Follow me on Linkedin
Vote for my Community Mobile App Idea 💡
Proud to be a Super User! | |
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
73 | |
72 | |
38 | |
30 | |
26 |
User | Count |
---|---|
99 | |
87 | |
45 | |
43 | |
37 |