Convert Power Query transformations into SSIS (ETL) and also SQL Server stored procs

[WalterL]

Imagine using the capabilities of SSIS or plain SQL Server and/or to execute Power Query transformations at high speeds. I see Power BI Designer as the transformations editor + small data transformation tool and SSIS/SQL as the big data transformation tool.

[nishalit]

Power Query is now available as a source in SSIS: https://docs.microsoft.com/en-us/sql/integration-services/data-flow/power-query-source?view=sql-server-2017

[mstacey]

There should be an SSIS data flow component that can execute M. That would be the ideal balance

[osvitek]

Explicit data transformation pipeline support in Power BI Desktop would be great. Same flow for data cleanup & mashup as now, but final step would be export to CSV instead of visualization. I know it's possible to export CSV data from visuals, but it's very limited.

[tdthoi]

Must have, now that a managed SSIS is available on Azure!