Concatenate qliksense to power bi

[siem]

Hello, on qliksense, I got this code :

LIENS:

Load Date_stock as DATE, '' as [ID vente], [ID STOCK] as [ID STOCK],[ID MAGASIN],[ID ARTICLE]

Resident STOCKS;

Concatenate(LIENS)

Load Date_vente as DATE, [ID vente] as [ID vente], '' as [ID STOCK],[ID MAGASIN],[ID ARTICLE]

Resident VENTES;

drop Field [ID MAGASIN],[ID ARTICLE] from VENTES;
drop Field [ID MAGASIN],[ID ARTICLE] from STOCKS;

On power Bi, I export my 2 tables  VENTES and STOCK

And I try to create a new table "LIENS" to do same thing then on qliksense.

But I don't see how to do it on power BI, because when I open power query, I don't have my new table "LIENS" that I created

Thanks in advance

[amitchandak]

@siem , In power query we have append and merge 

https://radacad.com/append-vs-merge-in-power-bi-and-power-query

Append Tables (Power Query)
https://www.youtube.com/watch?v=KyXIDInZMxk&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=15

Merge Tables (Power Query) : https://youtu.be/zNrmbagO0Oo

Power BI: Power Query Functions one must know
: https://www.youtube.com/watch?v=cN8AO3_vmlY&t=36407s

Power Query Append- Table.Combine: https://youtu.be/YdqOypKHsRU