PowerQuery is a very powerful when extracting data in tabular format from web sources such as RSS feeds, APIs, scraping web pages etc.
SSIS currently doesn't have anything approaching the simplicity and speed of development for extracting web data that PowerQuery exhibits.
For example, recently I redeveloped a solution that sourced timesheet data from a cloud based application (workflowmax) in PowerQuery. The PowerQuery "ETL" took about 20 minutes to complete. The previous solution used SSIS packages that had days of work put into them, and the reliability and simplicity did not come close to that provided by using PowerQuery.