Add PowerQuery Source connector to SSIS - by jakubk

Status : 

 


14
0
Sign in
to vote
ID 1046883 Comments
Status Active Workarounds
Type Suggestion Repros 0
Opened 12/4/2014 5:13:23 PM
Access Restriction Public

Description

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.
Sign in to post a comment.
Posted by Microsoft on 1/12/2015 at 10:03 PM
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.

thanks
SSIS team