Forum Discussion
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...
- Thanks Bob!
According to this article the limits apply to Power BI too
https://community.powerbi.com/t5/Desktop/Lookup-Column-Threshold/td-p/536456
However, saying that and as you see by the article it isn’t 100% clear. I would personally recommend raising this one to Microsoft Support to get a workaround or confirmation of the limit.
Hope that answers your question!
Best, Chris
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?
Thanks Bob!
According to this article the limits apply to Power BI too
https://community.powerbi.com/t5/Desktop/Lookup-Column-Threshold/td-p/536456
However, saying that and as you see by the article it isn’t 100% clear. I would personally recommend raising this one to Microsoft Support to get a workaround or confirmation of the limit.
Hope that answers your question!
Best, Chris
According to this article the limits apply to Power BI too
https://community.powerbi.com/t5/Desktop/Lookup-Column-Threshold/td-p/536456
However, saying that and as you see by the article it isn’t 100% clear. I would personally recommend raising this one to Microsoft Support to get a workaround or confirmation of the limit.
Hope that answers your question!
Best, Chris
Thanks for the responses ChrisHoardMVP !