Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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.