Jun 04 2019 10:45 AM
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 Server Error. (The query cannot be completed because the number of lookup columns it contains exceeds the lookup column threshold enforced by the administrator.).....
I found a post suggesting to connect using OData, but I am getting a similar error there.
I haven't found any documentation regarding what this threshold is, or if the administrator can change that. Can anyone provide some guidance on this?
Jun 04 2019 11:07 AM
Jun 04 2019 11:47 AM
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?
Jun 05 2019 02:52 AM
SolutionJun 06 2019 04:27 AM
Thanks for the responses @Christopher Hoard !
Jun 05 2019 02:52 AM
Solution