Solved! Go to Solution.
I could suggest currently using Power Update in order to update the data in your Excel (Power Pivot/Power Query) workbook for On-Premise data. It also does give you the ability to update your data, as well as upload it into OneDrive for Business.
You can read about it here: http://www.powerpivotpro.com/2015/02/introducing-power-update/
I hope that it helps!