Loading data (appended querries)

[jorge_ts]

Hi to all ! 

I struggle to solve the following issue (if it is solvedable of course)

I have query/tableA (which data does not changes) loaded by folder

I have query/tableB (which data changes) loaded by .xlxs

Both are append to new named ComboData.

In tableA I deactivated the Data Load and Refresh.

In tableB I deactivated the Data Load.

When I close & aplly power query, or refresh data,  ComboData gets all data from tableA and tableB.

that makes very slow refreshing data... Especially if I have to add a new table of data it makes all procces very slow and difficult....

Is there a way to make it more fast?

Thank u!!!

[amitchandak]

@jorge_ts , Increase Data Cache management to 8/10 GB and do following setting

[jorge_ts]

it seems to help but to little...

the data sets are excels with many many rows....

One (not to update) query loads about 2G of data! And is appended with the one that is almost 500Mb and gets updated.

thank you for the advice