For many reasons after the service has run its scheduled refresh I need ot get certian tables or reports published to csv/xlslx for 3rd party software to access. For example our CRM depends on regular 2 hourly updates of order status etc.
So as well as the manual "publish in excel" button it would maybe be a publish to excel on every refresh. Something that doesn't involve manual intervention to get the data in consumable format.