Status:
Completed
Convert Power Query transformations into SSIS (ETL) and also SQL Server stored procs
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.
5 Comments
- 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
- There should be an SSIS data flow component that can execute M. That would be the ideal balance
- 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.
- Must have, now that a managed SSIS is available on Azure!
- Status added:Completed
