Forum Discussion
akhaliq7
Post Prodigy
Post ProdigySharePoint 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
lbendlin
Super User
Super UserExperiment with Table.Buffer
akhaliq7Post Prodigy
Post ProdigyI ended up using sharepoint.contents instead of the default for the sharepoint folder connection
- Einomi
Helper V
To use SharePoint.Contents is recommended by Wyn hopkins instead of SharePoint.Files/Folder
- akhaliq7
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.
- lbendlin
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.