Forum Discussion
OData Feed SharePoint List Data Refresh Issue: Too Many Lookup Columns
Hi,
I am using PBI Desktop to create a dashboard and publish it to the server. As data source, I am using OData REST service to query the data in the form of https://<SERVER_NAME/_api/web/lists(guid'<LIST_GUID>')/items?$select=Id,Title with additional columns for a total of 20. In PBI Desktop, it loads as expected and gets refreshed without a problem.
When I upload to PBI Server, the OData Source Feed refers to the root data source https://<SERVER_NAME/_api/web/lists(guid'<LIST_GUID>')/items which gives back a 500 error, saying that "the number of lookup columns it contains exceeds the lookup columns threshold enforced". That is true for the entire list but that is not what I am instructing Power BI to do.
Is there any way to refresh the prefiltered data source instead of the entire list?
Thanks.
3 Replies
- AnonymousNot applicable
No one has ever encountered this?
- FarhanAhmedCommunity Champion
Did you checked this ?
- AnonymousNot applicable
I have, but it doesn't really provide useful information apart from the suggestion to increase the list view lookup column threshold, which is not really a best practice.