March 21, 2019
I have 3 PQ pulling sales data from an sql database for 3 business units loaded to tables. Then I have a 4th PQ to append the data. When I refresh the 4th PQ my goal is to pull the data that is in the 1st 3 PQ without having to wait for them to be refreshed (2-3 minutes each). However, the 4th PQ is taking just as long as to refresh as if the 1st 3 PQ were connections instead of table. The 4th PQ refresh status note flashes accessing the sql database. How do I get the 4th PQ to only pull the data already in the excel sheet table?
July 16, 2010
One option is to leave the first 3 queries in one workbook and in a new workbook write a new query that gets the data.
Alternatively, this post might give you some other ideas to improve power query refresh performance.