Get data from SharePoint Online Lists: Lookup columns threshold

[kompas_ua]

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

[ppm1]

Please see if the approach/function in this article avoids the error.

Updated – Get SharePoint List Data … Fast – Hoosier BI

Pat

[Zwakele]

Hi 

Did you find a solution for this?

[kompas_ua]

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...")

in

Source1

[jkball04]

@kompas_ua Could you provide your entire OData Query? Having trouble with mine.