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...