[TIPS] How to Install Power Query Connector in VS2019 SSIS

 [TIPS] How to Install Power Query Connector in VS2019 SSIS

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

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

It's a little tricky when I tried to install the Power Query for my Visual Studio 2019.

At first, I just installed the x64 one and the Power Query connector didn't show in SSIS Toolbox.

Finally, it appeared in SSIS Toolbox after I installed the x86 version as well.

 ===========================

Check target server version property

If Power Query Connector still not showing in your SSIS Toolbox after above steps, you can double-check the TargetServerVersion property of the project. 

If you installed the 2019 version, for example, this property needs to be set to SQL Server 2019. And the same for 2017.

Right click the project name in Solution Explorer, choose "Properties", go to "Configuration Properties" - "General", set up the TargetServerVersion to your SQL Server version.