Forum Discussion
Query Loading Slow in Desktop linking to SharePoint Folder
Hi Kaycee ,
If the dataset is small, everything is fine. If the dataset is large, we have to keep everything simple. For example, less join or merge which could double the data and slow down the performance.
You can also try to disable File > Options and settings > Options > CURRENT FILE > Data Load > Allow data preview to download in the background.
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Liang,
Unfortunately the issue is before any editing is done. The query will load the list of files on OneDrive for Business with relative speed, however something as simple as filtering to a single filename takes an extended time to load.
I've just done some further testing and realised there are thousands of files on this One Drive as it includes an extensive photo Library.
I tested by first filtering on the required folder (which would have far less unique combinations), and then on the filename. Performance improved substantially, although still a little slow.
Would it be a fair assumption that because of the significant number of unique filenames, by filtering on this first performance was significantly degraded by having to check each value individually?
If so, with now a clearer understanding of the issue - do you have any other recommendations for approach given you have to load the whole SharePoint/OneDrive location to begin?
Thanks
Kaycee
I'm having exactly the same issue as Kaycee - I'm loading files from a Group Sharepoint and it's taking the best part of 30 minutes to load the results.
The tables aren't large at all - maybe 30 lines for the largest - but the folder is massive (thousands of files stored). I feel like I'm on the same page as Kaycee but I don't see any way to speed up the query.
Luckily the files aren't consistently updated but I'm thinking about changing the connection to an excel connection and locating the file through the synced folder on my PC in the hopes that this will reduce the processing time.
It would be great to be able to local the file more efficiently (without loading all the files in order to locate one).
