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?