Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable

    No one has ever encountered this?

      • Anonymous's avatar
        Anonymous
        Not 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.