Integrate SSIS with the Power Query Excel Add-In as a Data Source. Solution needs to be all on-prem to avoid typical cloud concerns. Ideally can reach into a workbook for a specific Query or function...
I should add, with the option to complete the refresh by either updating the Excel file, or by picking up the output from the Query and passing it along an SSIS dataflow - Power Query as an SSIS Data Flow Source.
