I have a power query that pulls data from another workbook when you enter some criteria and hit refresh, pulling it into a table I call DataTable - that all works fine.
But I want to make another tab with a power query that offers a summary view - and instead of duplicating all the code again I want to just have it run off the results I've already run. The problem is that it seems to be stuck using whatever data was saved to the workbook rather than whatever I've run.
Like for example this:
let
Source = Excel.Workbook(File.Contents("\\servername\path\thisworkbook.xlsm"), null, true),
Data_Table = Source{[Item="DataTable",Kind="Table"]}[Data],
...
Doesn't actually seem to work even though it's targeting the right table - it only works if I refresh DataTable and then literally save the file, and then run the summary query. I want to be able to refresh all of it in the same shot regardless of whether I've saved the file yet or not. Is there a way to force it to update its connection or data?