PowerQuery has a lot of potential but it is currently limited to a desktop. I'd love to be able to run power queries on a server that can load data directly to DB.
It is possible to do this, but it is using undocumented Microsoft APIs and may violate the EULA. Microsoft need to realize the value of M and the Power Query/BI Editor and start developing it out to supplement or supersede SSIS. The editor enables people who are most familiar with the data (business users) to tame and curate data, there is HUGE value in that. We would use it extensively to prepare data for our Data Lake and Data Mart - pursuing this would really begin to make Power BI a 'killer app'. See the following link on how it can be done currently: https://stackoverflow.com/questions/40432718/is-there-any-way-to-invoke-powerquery-m-outside-of-excel-or-powerbi/54898353#54898353
