Forum Discussion
Dataflows vs SSIS
pbiuser10 I would spend my time getting to know and understand dataflows as that is the future. But that opinion doesn't mean anything if you aren't using the cloud, do all your work in SQL on premises, etc. Then learn SSIS.
Dataflows will open doors for the organization above and beyond what SSIS does in terms of centrally locating important data, based on all the M queries and ETL code you write in your Power BI files, and support all the latest and greatest MSFT offers with new features. SSIS is an old standby and really only way you could do ETL, things are changing, if you can - I suggest focusing on dataflows.
pbiuser10 I would spend my time getting to know and understand dataflows as that is the future. But that opinion doesn't mean anything if you aren't using the cloud, do all your work in SQL on premises, etc. Then learn SSIS.
Dataflows will open doors for the organization above and beyond what SSIS does in terms of centrally locating important data, based on all the M queries and ETL code you write in your Power BI files, and support all the latest and greatest MSFT offers with new features. SSIS is an old standby and really only way you could do ETL, things are changing, if you can - I suggest focusing on dataflows.
Seth - awesome answer and quite aligned with what I suspected. We are a mixture of cloud & on-prem, so DF seems like the right choice.
BTW, grew up in Green Bay (nowhere near there anymore)...but Go Bucks!