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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Top Solution Authors