Forum Discussion

BobAtkinson's avatar
BobAtkinson
Copper Contributor
Jun 04, 2019
Solved

Lookup Column Threshold - Can't Connect to SharePoint Online List

Hi there, I am trying to connect to a SharePoint Online list but am getting the following error: DataSource.Error: SharePoint: Request failed: The remote server returned an error: (500) Internal Se...
Lists
SharePoint Online
ChrisHoardMVP's avatar
ChrisHoardMVP
MVP
Jun 04, 2019
Hi Bob,

Per several articles the threshold is 12 which was raised from 8.

https://powerusers.microsoft.com/t5/General-Flow-Discussion/SharePoint-lookup-column-threshold-enforced-by-the-administrator/td-p/238839

https://powerusers.microsoft.com/t5/General-Discussion/SharePoint-too-many-lookup-columns-cause-query-failure-PowerApps/td-p/12211

https://natechamberlain.com/2018/09/04/how-to-increase-lookup-column-limit-in-sharepoint-lists/

This looks like a hard limit. This article does suggest you may be able to work around it by setting a view with 12 or less

https://blog.portiva.nl/2018/07/04/microsoft-flow-get-item-from-list-with-more-than-12-lookup-columns/

However, there is no getting around that limit in SharePoint Online.

Hope that answers your question

Best, Chris
  • BobAtkinson's avatar
    BobAtkinson
    Copper Contributor
    Jun 04, 2019

    HiChrisHoardMVP ,

    Thanks for the reply.  I'm afraid I left out a key component.  I am able to access the list on the site itself through all of its views, but I get the error when I am trying to connect to the list with Power BI.  I have tried  connecting to both a SharePoint Online List and an OData Feed.

     

    Are you aware of any limitations on the Power BI side that are preventing me from connecting?

Resources