Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Please see if the approach/function in this article avoids the error.
Updated – Get SharePoint List Data … Fast – Hoosier BI
Pat
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...")
in
Source1
@kompas_ua Could you provide your entire OData Query? Having trouble with mine.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.