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
I still do not see it in VS2019
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.
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
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.
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.
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.
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.
You are most welcome
Thanks a lot simone indeed installing Ssis PowerQuery_2019_x86 helped and the Power Query icon appeared
Hi ,I downloaded 64 bit for Vs 2017. But it doesn't appear. Any suggestions please?
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
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.
You are most welcome !
Thanks Greg!
You are most welcome !
so now we need to need install the whole sql server with SSIS, visual studio and powerquery source in order to develop a powerquery package?
Why is not possible to develop on a computer without sql server installed and then deploy on a server?
Hi Federico,
Why do you think there's a need for SQL Server itself on the development machine? (Although I always have it there anyway) I don't recall a dependency on that.
Regards,
Greg
It didn't allow me installation of Power Query source without a SQL Server installation, when I did it on my windows server where SQL server installed, the installation went fine.
Interesting. It'll be some dependency that's installed by default with SQL Server. What was the issue when you tried it without SQL Server installed?
Hello Greg,
I just came across the Power Query source for SSIS. I am running SSDT 2017 (latest version) as a separate installation. I tried installing both the 32 and 64 bit versions of the Source, but nothing is showing up. Do you have any ideas as to why this might be happening?
Hi Stephan, note there are both 2017 and 2019 versions of both 32 bit and 64 bit. Was it definitely the 2017 ones that were installed? Also make sure your target version in the project's properties are 2017.
Hi Greg,
I am trying to install the Power Query connector for VS but I get an error that I have to install the SSIS first, which I already have. Could you please assist?
Hi Narin, what exactly does the error say? Also, when you say you have SSIS, is that the SSIS engine, or is it the SSIS extension for VS, or both?
thanks for the information. after following your instructions followed by a system reboot, the PQ connector is back/working.
You are most welcome
Hi ,
I installed 2019 VS on my 64 bit laptop but I am not able to see power query in my ssis tool box inside. Is it I have to install 32 bit VS instead of 64 ?
More than likely yes.
Up to VS2019, VS was 32 bit. It's 64 bit from VS2022 onwards.