Forum Discussion
Get data from SharePoint Online Lists: Lookup columns threshold
Hello Everyone,
When I try to get data from SharePoint Online list I receive the error:
DataSource.Error: SharePoint: Request failed: The remote server returned an error: (500) Internal Server Error. (The query cannot be completed because the number of lookup columns it contains exceeds the lookup column threshold enforced by the administrator.)
Details: DataSourceKind=SharePoint
Yes, I know about this threshold in SharePoint, but in SharePoint Online I cannot increase the threshold. Is there any workaround?
Best wishes,
Sergey
4 Replies
Hi
Did you find a solution for this?
First workaround I’ve found is a OData query.
The strategy is to split the wide list. Try to create a several queries from a list, and then merge it into one wide table (joined by ID column). In this case you should create OData query manually for each chunk of the list.
For example:
let
Source1 = OData.Feed("https://###.sharepoint.com/teams/Projects/_api/web/lists/GetByTitle('Project List')/items()/?$select=Id,Title,Market/Id,Market/Title&$expand=Market")
in
Source1
kompas_ua Could you provide your entire OData Query? Having trouble with mine.
Please see if the approach/function in this article avoids the error.
Updated – Get SharePoint List Data … Fast – Hoosier BI
Pat
