Power Query Refresh Order

Hi All.

I need some info on excel power query refresh. I have 14 power queries in one excel file. 1 sheet uses 10 pqs and I know the order in which I created them (some build upon the others). The 1st 3 of the 10 pull data from 3 different tables on an sql server and the rest modify / manipulate / merge / group / etc the data pulled... culminating in the final query (#10) that populates the excel sheet. I have a cmd button on the excel sheet and I want to refresh the data without vba "ActiveWorkbook.RefreshAll" - I dont want to refresh data that is used on other sheets - to save update time.

So.. Do I refresh the pqs in the order of creation (mimicking the dependencies)? Table 10 is based off table 9 (which is off table 5) and table 8 (which is off table 5) and table 7 (which is off 6 and ) and table 4 (off table 3) and table 2 (off 1).... (something like this)..

Or, can I refresh the 1st 3 sql server queries only and just the last one #10? Will refresh of #10 cause the predecesors to refresh also? Or do I need to refresh all in the order in which I created them (building in order)

Thanks
Steve
Harrisburg, PA

Yes, I can refresh all, but I don't want to refresh queries that do not belong to that sheet. I only want to refresh what is needed to update the one sheet.

If I just refresh the final query (while showing the "queries & connections" command bar, I see the final query spinning only. I do not see the preceeding queries update.. and I do not see the 2 sql server source queries spin (update)

Here is an update. I just realized this. I have a Range(BU_NAME_RANGE) from excel that I concatenate into my 1st sql statement... If I change the value in the excel range, and just refresh #10, the data comes back with the new where!! That means that when I refresh #10, #1 had to be refreshed!!!

Please Login or Register  to view this content.