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...
Agree, suggestion is up on connect too - https://connect.microsoft.com/SQLServer/feedback/details/1046883/add-powerquery-source-connector-to-ssis
