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