O'Reilly logo

Microsoft® SharePoint® Designer 2010 Unleashed by Kathy Hughes

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

List Throttling

The default limit on items returned when creating an External List is 2,000. When trying to return more items, you get the following non-descript error:

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

When you hit this issue, you have two options: apply a filter as described earlier in this chapter or increase the limit. To change this limit, you need to get someone with Farm Administrator and Local Administrator rights on one of your SharePoint Web front-end servers to run the following PowerShell commands;

$bcs = Get-SPServiceApplicationProxy ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required