Development, Requirements, PowerQuery

Grab Excel Files from SharePoint without the SharePoint Connector(s)

Marc Mason
#Reporting#Power BI#PowerQuery
We all know that Sharepoint.Contents and SharePoint.Files have their uses, however they suffer from a massive speed deficit...

In this article I will show you how to use the OData connector and Web.Contents function to pull data from multiple Excel documents stored in a SharePoint folder. We will do this WITHOUT using the built in SharePoint connectors.

I first had the idea to avoid using the SharePoint connectors after trying to use them to pull 90 MB of Excel documents (about 120 files) from a SharePoint folder and it taking over 20 minutes. I thought, “there must be a quicker way to do this.”.

← Back to Blog