Streamline Power Query for Excel

[detriez]

I am just discovering the power or Power Query for Excel

I need to run merge queries to populate data on my daily file from the same master file every day and am trying to streamline the process.
My current process

1. Open my daily file
2. Get & Transform From Table/Range
3. In power query editor.. New Source > File > Excel
4. Open Master file
5. Merge queries
6. select map columns
7. merge
8. Add columns to daily file
9. Close & Load
10. Delete original data tab form daily file
11. Delete master data tab from daily file

Can I just reference the table on my master file without importing it and then deleting it?
Are there any improvements I can make to streamline my process?

 

[macfuller]

Are you asking if you can keep the previous data in the data model and just import the new daily file? If so, the answer is no. Every time you execute the query it's all or nothing - all data including anything new has to be run every time.

 

[detriez]

thanks for the reply.

Is it possible to link to the master sheet rather that import it in order to merge?

 

[sandy666]

I'm not sure what are you trying to achieve but maybe From Folder option would be the solution

 

[detriez]

I've found it!

Sorry I wasn't more clear

From the power query editor, rather than Close & Load... I needed to select Close & Load to.. Then only create a connection
This way, I'm not importing the reference data into my file, I am connecting to it in order to facilitate the merge

 

[sandy666]

so try this

leave both un-checked