Answered

Added Stored Procedure not available in SQL Transform Power Query list

(0) Share

Report

Posted on 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?

Categories:

Using connectors

I have the same question (0)

All responses (2)

Answers (1)

Krishna92 Microsoft Employee on at

Like (0)

Report

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

Was this reply helpful? Yes No
Verified answer

David Brandman 294 on at

Like (0)

Report

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.

Was this reply helpful? Yes No