web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / SQL Server Procedures ...
Power Automate
Unanswered

SQL Server Procedures Always GatewayTimeout

(0) ShareShare
ReportReport
Posted on by

I'm trying to get the rows that are added in the current day from a SQL Server table that contains all order data in these couple months.

 

I started by using 'Transform data using Power Query' to filter the data. It worked well when I first run the flow 2 months ago. The Timeout error just get more often to happen and my flow fails every time I run it because of the SQL procedure goes Timeout.

I've tried using 'Get Rows' and order it by creation time in desc, and get only a few hundred rows but the error still occur.

 

Is there any way I can get my data without doing anything to the SQL Server?

Thanks 

Categories:
I have the same question (0)

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 258 Super User 2025 Season 2

#2
trice602 Profile Picture

trice602 205 Super User 2025 Season 2

#3
Expiscornovus Profile Picture

Expiscornovus 204 Most Valuable Professional

Last 30 days Overall leaderboard