WalterL's avatar
WalterL
New Member
11 years ago
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.
  • tdthoi's avatar
    tdthoi
    Regular Visitor
    Must have, now that a managed SSIS is available on Azure!

Recent ideas