Take advantage of Excel Power Pivot and enable write-back to your data warehouse

Automate refresh and uploading files to OneDrive and SharePoint and Power BI

Excel is a great tool for sharing data with coworkers. However, keeping these spreadsheets up to date is tedious and cumbersome, especially if the are connected to Oracle, SQL Server, MySQL or any type of external data source.

Now, Power Update is your Excel Butler, that works rentlessly of keeping these spreadsheets up to date no matter where they are stored. Power Update downloads the workbook, refreshes all data connections and re-uploads them to: