I am facing following problem:
'Microsoft.SharePoint.SoapServer.SoapServerException' was thrown. Detail: The query cannot be completed because the number of lookup columns it contains exceeds the lookup column threshold enforced by the administrator.0x80070093
By following TechNet article: https://technet.microsoft.com/en-us/library/cc262787.aspx#ListLibrary, I get to know that there can be maximum 8 columns. But by following the TechNet link, it says:
To anyone having this same issue, we ended up having the SharePoint Admin increase the limit on lookup columns from 8 to 60. This immediately resolved the issue. The problem was that our domain admin accounts would work because they are outside of the parameters of the SharePoint rules set in our environment.
That means we can increase lookup columns !
I am a little confused; what's correct?