Skip to main content

    BI in SQL vNext

    New

    SSIS - integrate with Power Query (Excel Add-In)

    Vote (102) Share
    Mike Honey's profile image

    Mike Honey on 04 Feb 2015 09:31:27

    Integrate SSIS with the Power Query Excel Add-In as a Data Source. Solution needs to be all on-prem to avoid typical cloud concerns. Ideally can reach into a workbook for a specific Query or function, pass in function values if required, and trigger a refresh of a Query or all Queries.

    Comments (5)
    Mike Honey's profile image Profile Picture

    Richard Boland on 05 Jul 2020 22:56:07

    RE: SSIS - integrate with Power Query (Excel Add-In)

    But don't loose the beautiful SSIS debug screen! Power Query right now is awful at letting you know what's happening...

    Mike Honey's profile image Profile Picture

    Daniel Bartley on 05 Jul 2020 22:51:21

    RE: SSIS - integrate with Power Query (Excel Add-In)

    Yes power query all the things until on-prem is dead.

    But cloud first guys.

    Mike Honey's profile image Profile Picture

    Adil Majeed on 05 Jul 2020 22:51:20

    RE: SSIS - integrate with Power Query (Excel Add-In)

    Like Database to Azure SQL Datawarehouse, Analysis Services to Azure Anslysis Service, why not SSIS to Azure SSIS or in form of shape, I am supporting.

    Mike Honey's profile image Profile Picture

    Jakub Kaczanowski on 05 Jul 2020 21:59:58

    RE: SSIS - integrate with Power Query (Excel Add-In)

    Agree, suggestion is up on connect too - https://connect.microsoft.com/SQLServer/feedback/details/1046883/add-powerquery-source-connector-to-ssis

    Mike Honey's profile image Profile Picture

    Mike Honey on 05 Jul 2020 21:57:50

    RE: SSIS - integrate with Power Query (Excel Add-In)

    I should add, with the option to complete the refresh by either updating the Excel file, or by picking up the output from the Query and passing it along an SSIS dataflow - Power Query as an SSIS Data Flow Source.