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.”.