Forum Discussion

mim's avatar
mim
Advocate V
9 years ago
Solved

append the same table without double refresh

hi    is it possibe to append the same query without having to refresh both ?
Need Help
v-haibl-msft's avatar
v-haibl-msft
Microsoft Employee
9 years ago

mim

 

If I understand you correctly, you can try the solution provided in following two links.

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/13305798-append-data-to-existing-data-model

https://social.technet.microsoft.com/Forums/en-US/9d0ff65a-59b8-435b-be0a-b9c6a72264a3/separate-queries-refresh-with-append?forum=powerquery

 

According to this link, it seems that auto-refresh will always happen when using Power Query append function.

 

Best Regards,

Herbert

mim's avatar
mim
Advocate V
9 years ago

v-haibl-msft

 

thanks for the links, it is very helpful, my case is simpler ( I hope).

 

i have only one table and I need to duplicate that table, it seems if i append the same table, the refresh will be done two times, not sure if it is the case, as there is no easy way to profile powerquery.

 

maybe i will use Table.Repeat ?

 

sorry if i did not state my question clearly, so basicaly, i am happy to refresh everything, but i want PQ to do it only once not twice.

 

cheers