March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
I'm new to Power BI, coming from previous using Qlickview and SQL. I have tried searching the forum, but i must be searching for the wrong key words.
I'm trying to concenate 2 tables. NOT JOIN! concenate in the traditional database way.. Where i have a table called Orders. and a table called Sales. they both contain the sames fields. I wan't the concenated into 1 long table. how do i do that?
Example
Table: orders
Item no.
Date(presumed del. date)
amount
ordre no.
Type(Order)
Table: Sales
Item no.
Date(invoice date)
amount
ordre no.
Type(Sale)
If they are concenated into 1 big table. i can't now put both sales and presumed sales(orders) into 1 pivotable. So big question is how?? 😄
Solved! Go to Solution.
Hello,
Once you have your tables loaded into Power BI, you have a button on the top ribbon called Edit Queries. Once pressed, a Power Query Editor window will open, where you will be able to see your previous loaded tables. Again on the top ribbon, on the right you will see an Append Queries button that does the "concatenation". Then, you have to Close & Apply to get back to Power BI.
Here is actually a link to how this can be done:
https://www.youtube.com/watch?v=uAAOTi0VczA
But there are a lot of articles and video's on how to append queries in Power Query.
Or you can create a New Table in Power BI and use Union to concatenate the two tables
Regards,
ElenaN
Hello,
In Power Query you can use the Append Queries option.
Regards,
ElenaN
So i would first do a power query,, then do power BI.. No functionality directy in power bi to append, or am i missunderstanding you?
Hello,
Once you have your tables loaded into Power BI, you have a button on the top ribbon called Edit Queries. Once pressed, a Power Query Editor window will open, where you will be able to see your previous loaded tables. Again on the top ribbon, on the right you will see an Append Queries button that does the "concatenation". Then, you have to Close & Apply to get back to Power BI.
Here is actually a link to how this can be done:
https://www.youtube.com/watch?v=uAAOTi0VczA
But there are a lot of articles and video's on how to append queries in Power Query.
Or you can create a New Table in Power BI and use Union to concatenate the two tables
Regards,
ElenaN
Thanks.. exactly what i needed.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
129 | |
90 | |
75 | |
58 | |
53 |
User | Count |
---|---|
200 | |
104 | |
101 | |
67 | |
55 |