Automatic page refresh not working on appended table?

I have 2 sql sources imported with direct query.

Needs to be direct query so automatic page refresh works.

And on these 2 sources files it works perfect. However I need to append these 2 sources in 1 main table.

Now this is what happens :

The change detection is on the quantity field of the Pick/Pack source table.

As you see both the Pick and Done tables did refresh but the appended (Combined) table did not.

Find this very strange as it is appended and the 2 tables it consists out are updated!

Why does the appended table then not update??

Thought it had to do with the fact that the change detection field is not in the combined visual but....:

The field updates in the combined visual but the lines do not!! 

Does anybody know what is going on here?

The dataset on which all visuals are based is updated but the visual on the appended data does not update for some reason.

Also when in desktop I look in the table for the appended data and the lastes timestamp is not there.

So the auto refresh is not on the dataset but on the direct query source only somehow??

It is not the same as this button?