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...
Like Database to Azure SQL Datawarehouse, Analysis Services to Azure Anslysis Service, why not SSIS to Azure SSIS or in form of shape, I am supporting.
