How To Increase the Default Throttle Size for BCS in SharePoint 2010

If you have received the Error Message:

"Unable to display this Web Part. To troubleshoot the problem, open this Web page in a Microsoft SharePoint Foundation-compatible HTML editor such as Microsoft SharePoint Designer. If the problem persists, contact your Web server administrator."


There is a good chance you are experiencing the default 2000 item limit in place for the SharePoint 2010 BCS configuration. Follow the steps below to resolve:

1. Open the Microsoft SharePoint PowerShell Prompt as Administrator:

Go to 'Start' > 'All Programs' > 'SharePoint 2010 Products' Then Right Click on 'SharePoint 2010 Management Shell' to open SharePoint PowerShell as an Administrator.


2. Execute the following commands in SharePoint PowerShell:


Command 1:
$bdcProxy = Get-SPServiceApplicationProxy | where {$_.GetType().FullName –eq (‘Microsoft.SharePoint.BusinessData.SharedService.’ + ‘BdcServiceApplicationProxy’)}


Command 2:
Get-SPBusinessDataCatalogThrottleConfig -Scope Database -ThrottleType Items -ServiceApplicationProxy $bdcProxy | Set-SPBusinessDataCatalogThrottleConfig -Maximum 100000000 -Default 500000


Command 3:
Get-SPBusinessDataCatalogThrottleConfig -Scope Database -ThrottleType Items -ServiceApplicationProxy $bdcProxy


Now verify that the output looks like this and you're all set!


Scope : Database
ThrottleType : Items
Enforced : True
Default : 500000
Max : 100000000