Skip to main content

Notifications

Community site session details

Community site session details

Session Id : Qhn1baGhNByh6Vu8IlxU6A
Power Automate - Using Connectors
Answered

Added Stored Procedure not available in SQL Transform Power Query list

Like (0) ShareShare
ReportReport
Posted on 4 Jun 2020 17:58:18 by 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?

 

  • Verified answer
    David Brandman Profile Picture
    294 on 04 Jun 2020 at 22:32:27
    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 Profile Picture
    Microsoft Employee on 04 Jun 2020 at 18:48:21
    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Leaderboard > Power Automate - Using Connectors

#1
DBO_DV Profile Picture

DBO_DV 25 Super User 2025 Season 1

#2
CU09051456-0 Profile Picture

CU09051456-0 22

#3
Michael E. Gernaey Profile Picture

Michael E. Gernaey 21 Super User 2025 Season 1

Overall leaderboard

Featured topics

Loading started