Streamline Power Query for Excel

detriez

Board Regular
Joined
Sep 13, 2011
Messages
193
Office Version
  1. 365
Platform
  1. Windows
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?
 

Excel Facts

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.
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.
 
Upvote 0
thanks for the reply.

Is it possible to link to the master sheet rather that import it in order to merge?
 
Upvote 0
I'm not sure what are you trying to achieve but maybe From Folder option would be the solution
 
Upvote 0
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
 
Upvote 0
so try this

qo.jpg


leave both un-checked
 
Upvote 0

Forum statistics

Threads
1,213,551
Messages
6,114,267
Members
448,558
Latest member
aivin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top