OData Data Refresh - including custom Power Query formulas inclusing OData.Feed

We use OData.Feed to connect SAP HCM through an enterprise gateway. SAP will keep query results ready as they are scheduled jobs. Each result can be called with a "?$filter=RUNNUMER eq [nb]" attached to the uri. So, to load a number of runs, I need to build a unique connection for every run. In PBI desktop, loading of a large number of runs can be done via ie. a table with a running number used as run nmb in the uri attachment, or with a recursive function, too. Right now, we use a workaround and save the result in an excel file on sharepoint. A computer will refresh the file once a day and save it to sharepoint. But, for data protection issues, we need the direct connection without having to save a copy in order to hand it over to power bi service.