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.