Forum Discussion
Query Loading Slow in Desktop linking to SharePoint Folder
Thanks for the comment Thejeswar - my situation is exactly the same as yours, I have 19 files all stored in the same location that are being altered in the same ways and then appended after the alterations are complete.
It does sound inefficient that each table is performing its own search for the file when the search was already completed on the first table, I just need to tell the table to pick a different file from that same folder.
How did you resolve the issue?
Hi c_cook28954 ,
In my case, the file was using the OneDrive for Business connector and they had created separate connections for each of those files. So I reused the same connection for all the files.
But since you are using SharePoint Source, instead of connecting separately for each of the 19 files, create one SharePoint Folder Connection and locate your file from that.
Try to reuse the same connection for all the sheets
For your reference,
You will be seeing only one connection that powers all your files
In this case, I have 2 Queries that are using One Sharepoint source. Since you are connection at the sharepoint folder level, you can import the files even if they are in different folders. Just filter the right Folder Path in the connection
Right, I see what you're saying now - I'm fairly confident that I've already done that as I duplicated the table and only edited the file name in the advanced query.
I've checked and can confirm that I'm only using one Sharepoint connection to store the data so that doesn't seem to be the cause of the speed issue: