"REAL" concenate of tables

[Anonymous]

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?? 😄

[ElenaN]

Hello,

In Power Query you can use the Append Queries option.

Regards,

ElenaN

[Anonymous]

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?

[ElenaN · Accepted 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

[Anonymous]

Thanks.. exactly what i needed.