Power Query Schedule Queries
Would be great if you could schedule data connections/queries to refresh within an Excel file on a set schedule. Nightly, Weekly, recurring day/time each month, etc.
Scott McGee commented
You can get this functionality for free with a COM Add-in named Power SQL Update. I've been testing it for a week. Documentation is pretty bad, but functionality is great as is flexibility and options.
The free version will run forever, but you're limited to one file to update. But you can install it on every machine running PowerPivot and update 1 file, as many times as you want! So if you have a bunch of machines, you can update a bunch of PowerPivot models. Otherwise, if you want to update multiple files, it's like $600...
Microsoft should pay for the rights to this code and incorporate the functionality into 64-bit Office Professional and O365. After all, professionals are the only ones that would use it, and professionals EXPECT this kind of capability in professional quality apps.