Add PowerQuery Source connector to SSIS
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.
Upvotes: 18<=-=Jan 12 2015 10:03PM=-=>
Thank you for submitting this feedback. After carefully evaluating the bug, we accept the bug as a valid bug that we will plan to fix it. We do not have a specific release date at this point but we will work on this feature, and will try to release it in the next version of SQL Server.
Thanks again for reporting the product issue and continued support in improving our product.
Dmitry Ponkratenko commented
It would be great if the power of using Power Query Source appeared as an update for SQL Server 2017 Integration Services.