Search for answers or browse about Sintel Forms.
Error when attempting to view data in a data source
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.
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.
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). Within SharePoint the following column types are considered lookups:
- Lookup columns
- Managed metadata (single and multi-value)
- People and group (single and multi-value)
- Workflow status columns
- Created by (People and group)
- Modified by (People and group)