PowerQuery in SSIS... is it only in 2023?

• pietlinden

  SSC Guru

  Points: 63587

  More actions

  November 29, 2023 at 9:57 pm

  Go to Answer

  #4336951

  First off, I'm terrible at SSIS... I'm trying to create a PowerQuery data source, and it's flat out not there in VS 2022 (yes, I have the rest of SSIS installed).

  is it only in 2023?  is there a good rank beginner article on getting started with it somewhere? I saw one, but I wanted to figure out why I can't even see the PowerQuery transform in SSIS.

• Martin Schoombee

  SSCoach

  Points: 19135

  More actions

  November 29, 2023 at 10:00 pm

  Answer

  #4336954

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

  Full reference here: https://learn.microsoft.com/en-us/sql/integration-services/data-flow/power-query-source?view=sql-server-ver16

  The purple boxes in the articles are your friend