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...
Yes power query all the things until on-prem is dead. But cloud first guys.
