Forum Discussion
Using Excel as a 'back end' with Power Apps & PowerBI
This may be something which has been done before, but I wasn't able to find any explicit resources on it being done, so thought I'd ask. My organisation has a large number of models which have be...
3. Hosted the Excel on OneDriveData sources on OneDrive/Sharepoint do not require a gateway and when they change they "usually refresh the dataset within the hour" (as per Microsoft). If that's not good enough for you you can add these data sources to the gateway (warning:irreversible) and then use API refresh (for example) to speed up the process/make it more predictable.
I sincerely wish that you can move on from that frankensolution to a proper setup posthaste.