Forum Discussion
SharePoint Online slow refresh
As the title says. I have seen this issue posted several times but never found anything that may help. My reports pull from both a SQL db and several SharePoint lists. The SQL dbs will import 100,0...
SharePoint on-prem and online does some sort of IP address-based throttling. I spent days working on a multi-threaded application to update a "large list" in SP and there was almost no befenift to doing single vs mulit-threading / thread-pooling. In the end, I ended up doing a distribuited app approach.
Some of the API-based solutions mentioned in this thread are FAST, but I've never been able to get them to auto-refresh once published.
Thanks for that! I might try pushing it to an excel file stored in sharepoint online and pulling it in with an odata query. That might have the same problem you were describing though...