Added Stored Procedure not available in SQL Transform Power Query list

Like (0) Share

Report

Posted on 4 Jun 2020 17:58:18 by David Brandman

294

When using a SQL Transform Power Query in my flow, using a Connector I already had set up to my on-prem SQL database, I went back and created a new SQL Stored Procedure (SP) that I will need to call. But I do not see the newly added SP in the SQL Transform to pick. Is there a way to force a refresh so Power Automate see's it's been added?

All responses (2)

Answers (1)

Verified answer

David Brandman 294 on 04 Jun 2020 at 22:32:27

Like (0)

Report

Re: Added Stored Procedure not available in SQL Transform Power Query list

Changed it to a VIEW and it shows up and works. It seems it doesn't support Stored Procedures with the Gateway (I assume). THanks for feedback.
Krishna92 Microsoft Employee on 04 Jun 2020 at 18:48:21

Like (0)

Report

Re: Added Stored Procedure not available in SQL Transform Power Query list

@dBrand

Could you please try removing the data card and re-add it again in flow and check if you are able to see the stored procedure created.

Also could you please check on SQL server if the stored procedure has been successfully created or not.

Please try EXEC STORED PROCEDURE NAME and run the query if you are able to see the result it indicates that the stored procedure has been created and is running successfully.

If this information helps you with resolution, please consider giving a thumbs up and mark the solution as resolved.