Hi @Eric Klein Goldewijk，
I did several research that it seems we could not directly use the excel file on sharepoint as source.
The ways suggested is downloading the files first and then use it.
The OData source includes support for the following data sources:
- Microsoft Dynamics AX Online and Microsoft Dynamics CRM Online
- SharePoint lists. To see all the lists on a SharePoint server, use the following URL:
https://<server>/_vti_bin/ListData.svc. For more information about SharePoint URL conventions, see SharePoint Foundation REST Interface.
If the answer is helpful, please click "Accept Answer" and upvote it.