Forum Discussion
Solved
SharePoint runs slow when loading from folder
So I am trying to connect to the sharepoint folder to access data, but the refresh is really slow once I apply all the steps. First there are 70000 rows/files that load from my sharepoint. When I sea...
Experiment with Table.Buffer
Experiment with Table.Buffer
I ended up using sharepoint.contents instead of the default for the sharepoint folder connection
To use SharePoint.Contents is recommended by Wyn hopkins instead of SharePoint.Files/Folder
Yeh that is how I know this function seen his video on connecting to sharepoint folder also it does make a big difference in processing speed.
Technically SharePoint.Contents should be slower as it requires more steps to get to your data. You may have more luck with the API, or at least with using ODATA filters.