Forum Discussion
Query Loading Slow in Desktop linking to SharePoint Folder
Kaycee , c_cook28954 ,
I once came across a similar issue where the load of the tables from OneDrive was extremely slow. It was so slow that even after refreshing and leaving for hours, the data was not getting imported.
The Files were small only. They had less than 100 records.
When I checked further, I understood that the issue was not with the file, but with the connection. For importing multiple files, instead of reusing the existing connection in the Power BI file, the files were using different connections for each file. In this case all the files were present in the same folder.
So I would suggest that you check on these lines as well.
May be the connections are impacting one another due to all reading from the same location at the same time.
Regards,
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: