Forum Discussion
Reference query got refresh when base excel file changed
I Load the Excel file into power query editor, and then I create a reference query of the main excel query. Now if Excel file got updated then Is it reference file refresh or not.
Hi Anonymous ,
Yes, it will refresh. Taking a reference of a query just recreates the original query at its final query step so, if the original query gets refreshed and the table at the last step changes, then so does the reference query.
What I think you want to do is:
DUPLICATE your original query, then right-click your new query that you don't want to change and UNCHECK 'Include in report refresh'. This will stop it requesting new data when you refresh.
Pete