topic Re: OData Feed SharePoint List Data Refresh Issue: Too Many Lookup Columns in Report Server

OData Feed SharePoint List Data Refresh Issue: Too Many Lookup Columns

Anonymous — Mon, 09 Aug 2021 15:52:56 GMT

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.

Re: OData Feed SharePoint List Data Refresh Issue: Too Many Lookup Columns

Anonymous — Tue, 10 Aug 2021 09:20:29 GMT

No one has ever encountered this?

Re: OData Feed SharePoint List Data Refresh Issue: Too Many Lookup Columns

FarhanAhmed — Tue, 10 Aug 2021 11:53:48 GMT

Did you checked this ?

Re: OData Feed SharePoint List Data Refresh Issue: Too Many Lookup Columns

Anonymous — Tue, 10 Aug 2021 11:57:44 GMT

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.