Forum Discussion
Query Loading Slow in Desktop linking to SharePoint Folder
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: