I created external list in SP2013 which has more than 2000 rows but I still cannnot read it all, error is:
Database Connector limited response. The response from the database contains more than 2000 lines. The maximum number of lines that can be read by a database connector, is 2000. Restrictions may be altered through routine Set-SPBusinessDataCatalogThrottleConfig.
Here is result of powershell script from this site: and here from CA:
Only when I have new view in database with only 1999 rows or create filter limit in SPD, I can see the external list in SP. What can I do?