BI: Wondering where you Integration Services Connector for Power Query has gone in Visual Studio 2019?

I wrote recently about menu items being missing from SSIS and other BI projects in VS2019, but another thing that's gone MIA is the Integration Services Connector for Power Query.

This is the connector that allows you to use Power Query (and the M language) to input data into SSIS.

The SSIS designer for VS2019 recently went GA (general availability). It's great that it's released, but if you install it, you'll find it removes the Power Query option for SSIS.

I imagine the reason for that is that the connector is still in preview, where the rest of the designer is now GA.

To get the functionality back, you need to separately download the Integration Services Connector for Power Query. You'll find both 2017 and 2019 versions of it here:

https://www.microsoft.com/en-us/download/details.aspx?id=100619

 

14 thoughts on “BI: Wondering where you Integration Services Connector for Power Query has gone in Visual Studio 2019?”

    1. Hi Simone,

      Did you install both the x86 and x64 versions? At first, I just installed the x64 one and it didn't appear in VS2019. (After all it's a 32 bit app). The 64 bit version needs to be on 64 bit systems that the package needs to run on, and when debugging in VS2019. But I presume the x86 version needs to be there for design time in VS2019.

      1. Hello Greg,
        I have VS 2019 installed on my work station but when I try to install either versions of msi I get an error saying I need ssis installed. Does this mean that I have to have integration services installed on my laptop?

        -Vishal

        1. Great question. I have SSIS on mine so I didn't see that. Do you have the current SSIS designer extension installed in VS 2019? If not, it might just be that. There have been updates to it just lately.

          1. Yes Greg, I have installed SQL server Integration service Project V 3.6 on my laptop, but just to get the power query source working on it I downgraded it to V3.2 and it appeared in the tool box as expected. So there is no Power query source for V3.6.

          2. Hi Vishal, sorry, but V3.6 of what? In VS 2019, I have "SQL Server Integration Services" as an installed extension version 15.0.2000.94. (Which I believe is the latest version of the extension). I just tried it and it works in there.

  1. Greg,
    thank you so much for your prompt reply!
    Actually, I did install the 64 bits only. After reading your suggestion, I installed the 32 Bits …et voila', the "Power Query Source" icon re-appeared inside my Visual Studio 2019.

    1. Hi Chitwan,

      Did you install the 32 bit one as well? Keep in mind that VS2017 is a 32 bit application. Hope that helps.

      Greg

      1. Thanks for sharing the link and the info. I kinda freaked when Power Query dissipated on me. Installing both the x86 and x64 versions worked perfectly.

Leave a Reply

Your email address will not be published. Required fields are marked *