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

    b7a12628 4290-49ee-b676-85130b7a418d 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

    a466c1a2 a24a-42a4-a730-a99aba023c58 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

    d692d796 543a-4a74-8b44-abf77e3b58ec 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

    e3f6051b 72e0-4e76-b989-248d75c492a9 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

    af0019aa 9a7e-4776-9021-7b1171cd13bc 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.