insert into select like functionality using power query

[saranrajk]

Hi,

I'm trying to achieve a loginc like insert into select in sql using power query in power how to achieve it.

Thanks in advance

[belenrojo]

Did you found solution for your problem? I am having the same issue.

Thanks in advance,

Belén

[v-cherch-msft]

Hi @saranrajk 

It seems you may filter the table first and then use 'Append queries' in query editor.

Regards,

[saranrajk]

yes I tried with append queries, I'll tell what I'm trying to achieve.

lets say

1st table contains 100 records like full data

2nd contains 5 records and it changes every day

if I can insert data from 2nd table to 1st table 

on  first refresh the first table contains 105 data and on second refresh it will contain 110 data and so on.

If I'm using the append queries on first refresh it contains 105 records(100 data from 1st table and 5 from 2nd) and on second refresh it will again contains 105 data(100 records from 1st table and new five records from 2nd table and it will miss the data from previous refresh).

do have any idea about this

Thanks in advance.