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...
But don't loose the beautiful SSIS debug screen! Power Query right now is awful at letting you know what's happening...
