Forum Discussion

Re: Connecting and refreshing Excel workbook data

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!

 

Thanks

Gilbert Quevauvilliers