BDC WebPart Web Service Error

Problem
Web-part display the following error:

Solution

if ((gsnp '*sharepoint*' -ErrorAction SilentlyContinue) -eq $null){asnp *sharepoint*}

$bdcsap = Get-SPServiceApplicationProxy | ?{$_.TypeName -eq 'Business Data Connectivity Service Application Proxy'}

$tc = Get-SPBusinessDataCatalogThrottleConfig -Scope WebService -ThrottleType Size -ServiceApplicationProxy $bdcsap

Set-SPBusinessDataCatalogThrottleConfig -Identity $tc -Maximum 150000000 -Default 3000000

Explanation

$tc to get throttle config  for WebService scope. Scope can be Wcf, WebService, Database, Global, or Custom.

Set-SPBusinessDataCatalogThrottleConfig -Identity $tc to set new throttle config.

It took a minute or two to take effect and problem solved for now as usual.