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.
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
Recent ideas
Preserve Power BI Semantic Model Measures and Business Metadata When Generating Fabric IQ Ontologies
When Fabric IQ generates an ontology from an existing Power BI semantic model, it should preserve more of the business semantics that organizations have already invested in defining. Today, a semant...