Adding data to the end of a table with Power Query

[afila]

I've got my query that pulls data from sql server 2012 into excel using power query. However, when I change the date range in my query I'd like to pull the new data into my table and store it below the previously pulled data without deleting it. So far all I've found is the refresh button, which will rerun my query with the new dates but replace the old. Is there a way to accomplish this? I'm using it to build an automated QA testing program that will compare this period to last. Thank you. Or if there is an easier way to do this, suggestions are appreciated. I've got about 7 complex queries.

FYI, cross-posted here: sql - Adding new data to the end of a table using power query - Stack Overflow

http://www.excelforum.com/showthread.php?t=1143501

 

[Matt Allington]

You can append as many queries as you want. The general approach is to create the queries, set "load to, create connection only". Once you have them all, just append them together via the UI. But dependent queries will refresh predicate queries as needed, so I don't know if you can stop it refreshing the SQL this way


What at is the issue with refreshing against SQL? What is the issue with this?