As with Microsoft Exchange servers, throttling is also used on SharePoint.
SharePoint throttling
.Sometimes it is needed to turn it off in order for Data&More Toolbox to get data without any bottlenecks in the way.
SharePoint 2013 and 2016
To disable throttling, open up Powershell and enter next code block:
$web = Get-SPWeb http://<sharepoint>$list = $web.Lists["site_lists"]$list.EnableThrottling = $false$list.Update()
To validate that throttling settings are effective, type:
$list.IsThrottled