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

[Anonymous]

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.

[Anonymous]

No one has ever encountered this?

[FarhanAhmed]

Did you checked this ?

[Anonymous]

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.