cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
gidon
Helper II
Helper II

concatenate two tables to one

Hello

I have two table

1 - act   with 2000 rows

2 - tab1 with 3000 rows

i want to have tab1 into act 

and get one table named act that have 5000 lines

thanks

gidon

 

 

 

 

 

I want to

 

1 ACCEPTED SOLUTION

To Get rid of the duplicate tables, right click on the table you don't need loaded (left hand side in the queries view) and disable "Enable Load".  This keeps the query (that you need) and simply doesn't materialise it in the data model.



* Matt is a Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.

View solution in original post

4 REPLIES 4

I created a video for you to show you how to do it.  https://www.youtube.com/watch?v=uAAOTi0VczA 



* Matt is a Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.

Hi Math

The Append Function succed and I have now two tables one contain the two of them

the other table .

I do not the the other table , as it is combined the the Act table  .

 

do i have now duplicate tables  .

if i delete it , i will have the data in the next reload .

 

in qlik i prepare the table then concatnet them together  .

and drop the table , but the the script that I need for the next reload  .

how does ir works in power BI

can you calify it

thanks

gidon

 

To Get rid of the duplicate tables, right click on the table you don't need loaded (left hand side in the queries view) and disable "Enable Load".  This keeps the query (that you need) and simply doesn't materialise it in the data model.



* Matt is a Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.

View solution in original post

thanks

Helpful resources

Announcements
MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

July 2021 Update 768x460.png

Check it out!

Click here to read more about the July 2021 Updates

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Top Solution Authors
Top Kudoed Authors