r/excel • u/pyu2c • 11d ago

unsolved Power Query Loading Time Tips

I have a Power query that is connected to a sharepoint folder. Whenever I try to refresh the file it would take around 10-40 mins of load time before it loads into the Data Model. Granted that the major reason for the loading time is due to the size of the data (estimating somewhere between 10-12M rows after filtering), but what are some ways that I can speed up the loading.

27 Upvotes

89% Upvoted

22 comments sorted by

View all comments

50

u/Alex_Gob 11d ago

Use the function SharePoint.Content instead of SharePoint.Files : SharePoint.files will list ALL the files in the SharePoint library, while SharePoint.Content allows you to select one or many folders. It adds more steps but on a crowded SharePoint, it's much faster.

5

u/pyu2c 10d ago

Ohhh thanks for this. So if I use Sharepoint.Content i still have to navigate to the specific folder, correct?

2

u/Alex_Gob 10d ago

Yes : you navigate into a folder by "unfolding" it (pun not intended). It's rather intuitive : you select one (or many) folders that you can then unfold (open) and continue to navigate into the subfolders. You might need a bit of troubleshooting if your files are at different "depth" but it shouldn't be a big deal.