Data connection retrieve 1000 row only

Occasional Visitor

Hello Dears,

 

I have a problem regarding to retrieve data from a SQL connection in InfoPath form. I added the SQL connection in data connections section and it will retrieve the data when the form opened but it seems this connection has 1000 row limit so it retrieve only first 1000 row of the table (our table has more than 5000 row). 

 

I would appreciate if you could help me regarding to this issue.

 

SharePoint Version: 2019 On-premise 

SQL Server Version: 2017

 

Thanks in advance

 

0 Replies