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 / on premise data gatewa...
Power Automate
Unanswered

on premise data gateway get Rows

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

I am using on premise data gateway to get data from on-prem data base using get rows in flow and insert the records in azure DB.

In on-prem DB the table contains more than 50k records, and when i am running the flow only 2048 records are getting from the on-prem DB.

 

can anyone help to get the complete table rows from on-prem db and insert those in cloud db. or is it a limitation with gateway?

 

Categories:
I have the same question (0)
  • abm abm Profile Picture
    32,975 Most Valuable Professional on at

    Hi @flow3 

     

    Thats the default limitation. Click the three dots and under settings set the pagination on and set the threshold to 50k. I am not sure about 50K may be it is possible.  If not try with 10K threshold and see if it works. If you can limit by a filter query it will be good. 

     

    image.png

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…

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
trice602 Profile Picture

trice602 315 Super User 2026 Season 1

#2
David_MA Profile Picture

David_MA 273 Super User 2026 Season 1

#3
Power Platform 1919 Profile Picture

Power Platform 1919 117 Super User 2026 Season 1

Last 30 days Overall leaderboard