Skip to main content

Notifications

Power Automate - Using Connectors
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 

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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,445

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,741

Leaderboard

Featured topics