Forum Discussion
Data source error (500) spreadsheets in Teams folder
Your sharepoint instance is overloaded. Speak to your Sharepoint admin to figure out why.
Thank you, this has lead to me to the solution. SharePoint will only support views with 5000 items. I found that my SharePoint Library was keeping 500 versions. Since I have 12 spreadsheet this now exceeds the 5000 item limit. Even though I am not using all the versions in my query it was getting stuck on the step wehre I was filtering to the most recent version. Reducing the major version kept to the smallest number allowed (100) has fixed the problem.
Super UserYour sharepoint instance is overloaded. Speak to your Sharepoint admin to figure out why.
Thank you, this has lead to me to the solution. SharePoint will only support views with 5000 items. I found that my SharePoint Library was keeping 500 versions. Since I have 12 spreadsheet this now exceeds the 5000 item limit. Even though I am not using all the versions in my query it was getting stuck on the step wehre I was filtering to the most recent version. Reducing the major version kept to the smallest number allowed (100) has fixed the problem.