actualising of power query and tables/appending tables

[Anonymous]

Hello guys 
I have  an issue with my two tables below. On the left u get my first table and on the right my second one. Both tables i deconnected from excel(there is one excel file for two tables). So as u see my tables have different values. However when i append my tables (both deconnected) i get the third table below my first two tables and u see that there is only a data from my second table. I think that it is happening because while appending there is an actualisation and so power query goes to my excel file and take all recent data. However i would like to get the third table with different data from 1 table and second table and not just same data. 
Thank for your help

[Jimmy801 · Accepted solution]

Hello @Anonymous 

the thing is this. Power Query only makes the calculation, it doesn't store any values. So if your are referencing another query (it doesn't matter if its connected or not), the only way for a new query to access the data is to reload it. So there is not way to do that in power query. You have to go for DAX and merge the result (not updated one) in DAX, where the output of your two table has to be loaded at least once. In DAX you can use this Syntax

YourNewTable= UNION(YourQuery1;YourQuery2)

Hope this helps

If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too

Have fun

Jimmy

[Anonymous]

Yeap. I wanted it to be done in query for my purposes and not in DAX. Okay. Thank you very much for your answer