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

 

4 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. 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.

Leave a Reply

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