So I found this nifty guide, to avoid changing source from edit window
exceloffthegrid.com
Setup:
- I have two queries in the file, first one is using source information directly from cells (filepath and filename) to display a table
- second query is a reference to first query, to display a pivot of the same data (table contains more data and is for checking purpose, pivot is for extracting actual data).
Issue:
When I press "update all", the first table, which is taking the source data from the cells, does not update, but the pivot referencing the first table is.
First table is only updated if I manually select the query and press "update", then the data in table and pivot match.
Is this expected behaviour? Seems strange, that referenced query sees the changed path and updates OK, but the source query itself does not.
Change the Power Query source based on a cell value
Discover how to change the Power Query source based on a cell value. Amazing technique to build simple solutions for others to use.
exceloffthegrid.com
Setup:
- I have two queries in the file, first one is using source information directly from cells (filepath and filename) to display a table
- second query is a reference to first query, to display a pivot of the same data (table contains more data and is for checking purpose, pivot is for extracting actual data).
Issue:
When I press "update all", the first table, which is taking the source data from the cells, does not update, but the pivot referencing the first table is.
First table is only updated if I manually select the query and press "update", then the data in table and pivot match.
Is this expected behaviour? Seems strange, that referenced query sees the changed path and updates OK, but the source query itself does not.
