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

Be 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

Reply
Anonymous
Not applicable

"REAL" concenate of tables

 

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

1 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

View solution in original post

4 REPLIES 4
ElenaN
Resolver V
Resolver V

Hello,

 

In Power Query you can use the Append Queries option.

 

Regards,

ElenaN

Anonymous
Not applicable

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

Anonymous
Not applicable

Thanks.. exactly what i needed.

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.