0

We have created a SharePoint list with 50000+ items in it which has different views.

We exported the same SharePoint list using Export to Excel functionality.

After that we created a dashboard on SharePoint and connected that Excel dashboard to SharePoint List using OData Data Feed of Excel Connection.

But whenever we are trying to Refresh the excel dashboard data, it is showing You do not have permission to view entire list because it is larger than the list view threshold enforced by the administrator.

Kindly suggest a suitable solution.

Improve this question

1 Answer 1

Reset to default
0

This issue occurs because SharePoint Online uses the Large List Resource Throttling feature. By default, the list view threshold is configured at 5,000 items. When the defined item limit in a list is exceeded, the error message will be displayed. For SharePoint Online, this limit can't be changed.

Export a large list to an Excel will let you work with large list without blocking. But if you connect the table to the list (from OData Data Feed) using the listdata web service, it will throw threshold error if the list has more than at 5,000 items.

Information about how to manage large lists/libraries in SPO.

Improve this answer

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.