How Can We Help?

Search for answers or browse about Sintel Forms.

Error when attempting to view data in a data source

You are here:

Issue

When you attempt to view data in a Sintel BI Data Source you have created you receive an error similar to the one shown below.

List View Lookup Threshold Exceeded

List View Lookup Threshold Exceeded

 

Reason

In this case, the issue was caused by a large number of Lookup fields in the list used by the data source. SharePoint has a limitation whereby you can’t have more than 12 lookup columns in a list view and this also applies to Sintel BI data sources also.

Resolution

To overcome this issue you simply need to reduce the number of visible lookup columns in the Sintel BI data source by clicking on the eye icon to hide them (Lookup columns are indicated by an Asterix symbol). The following column types are considered lookups:

  1. Lookup columns
  2. Managed metadata (single and multi-value)
  3. People and group (single and multi-value)
  4. Workflow status columns
  5. Created by (People and group)
  6. Modified by (People and group)
List View Lookup Threshold Resolved

List View Lookup Threshold Resolved

Was this article helpful?
0 out of 5 stars
5 Stars 0%
4 Stars 0%
3 Stars 0%
2 Stars 0%
1 Stars 0%
How can we improve this article?
Please submit the reason for your vote so that we can improve the article.
Table of Contents