Andres Ramos Cevallos on 09 Mar 2016 00:19:17
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.
- Comments (3)
RE: Make PowerQuery a standalone server tool
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
RE: Make PowerQuery a standalone server tool
Power query is a powerful (and mostly underrated) tool for ETL. This is because it is limited to writing to Analysis services (1400) and PowerBI. It would be nice if the tool could write to other formats, such as blob stores, Data warehouse, document DB's., etc...
I cold see this as an eventual replacement for both data factory and SSIS
RE: Make PowerQuery a standalone server tool
Need Get & Transform/PQ to decouple & operationalize a full data capture & analytics solution on Azure. Maybe make this available in Azure Data Factory or in Logic Apps.