Schedule Daily Incremental Data Loads In Power Pivot

[Hopeless Cub Fan]

I am trying to figure out how I can automatically schedule daily excel data files to be appended to a power pivot dataset. The process I am envisioning is as follows:

• A large daily sales detail file exists in an excel table that is utilized in power pivot
• I receive a system generated daily sales detail file (with the exact same columns as the large master dataset) that is saved to a specified folder
• Power Pivot (Power Query??) automatically goes out to the daily sales file, opens it, and appends it to the large master table

The goal is to have this incremental data load happen automatically every day. I've downloaded Power Update, but it appears that this is for complete data refreshes. I am sure I can use some VBA to accomplish this, but would prefer to see if a better/easier solution exists before I go down that path.

 

[miguel.escobar]

glad that you found it useful!

So far there are no native tools for Excel that can create that "job" or windows service. Your best bet are:
1. Excel native stuff: leave the workbook open and set up the connection to automatically refresh every x amount of minutes or
2. A 3rd party software: use the free version of Power Update that can do just that.

Here's the link to Power Update: Power Update Adds Email Notifications, Macro Support, and 100% Free Version - PowerPivotPro PowerPivotPro