Change default values BCS service application for External Lists

When you want to use/show external lists in your SharePoint 2010 environment that have more then 2000 rows, you get the following error:

The above error is a pretty general error that doesn’t tell you the real problem. When you get this error through a mobile phone UI, you get a more detailed error:



The dialog above tells us that the external list has got a predefined maximum of 2000 rows. The amount of maximum can be changed by using PowerShell

Steps:

·         Open SharePoint Management Shell

·         Search for the ID of the BCS service application via the cmdlet: Get-SPServiceApplicationProxy

·         When you found your ID, enter the following command:

Get-SPBusinessDataCatalogThrottleConfig -Scope Database -ThrottleType Items -ServiceApplicationProxy  <fill in GUID here>, when you hit <Enter> you get the following information:

·         To change the default values, enter the following commands:

$Db = Get-SPBusinessDataCatalogThrottleConfig -Scope Database -ThrottleType Items -ServiceApplicationProxy 6b43909f-a52b-4d6e-8c06-631deccf8dcb

Set-SPBusinessDataCatalogThrottleConfig -Identity $Db -maximum 25000 -default 19000

·         After we ran the commands we see that the values are changed:

After that go back to the SharePoint environment and refresh you page, you now will see your rows from the external datasource in this external list: