We have been using power update (free version) for a few weeks now and would like to see if we can get it running more consistently being upgrading.
A little context:
RefreshEachConnection is set to False (only config change)
The task has 3 macros set to run after update
Refresh a measure-only pivot
Turn on automatic calculation
Save to shared drive
Destination is set to Sharepoint
The process generally executes as desired/expected in about 25m. Randomly the process executes in 9-15m, but none of the queries are updated. The saved files look identical to the source except for being an additional 100-200kb in size. There are no failure notifications when this happens. We seem to have fewer instances of this issue when we do not have power update call the automatic calculation macro after update.