Forum Discussion
power query and Excel "Refresh All" automation
I am using power query as a desk top ETL tool to load data from several sources. I am breaking up business logic in to heirarcy of excel spreadsheets. I am would like to automate the sequece on data...
Try using Power Update - I have been trying the free version for a couple of weeks. It seems to leverage MS Task Scheduler, impressed withthe email notification I recieve to let me know the workbook has been updated sucessfully.
Claims : Schedule the refresh of your Power Pivot Workbook as frequently as desired, Auto-Publishes to any location, and Sends you an Email Notificationof Success/Failures