Refreshing PBI Reports: Gateway

Hi everyone, 

I have a problem refreshing reports in PBI Service. Evrything I do looks manual and wanted to check if what I have been doing is right or not. Also, if you provide me possible alternatives, it would be great. 

So, I have a report that should be refreshed weekly. Mostly, I use Excel data source that should be always exported from a different cloud environment, but doesn't have a connector to PBI. I developed the Power BI report and published it in to Service. When I want to refresh it once in a week, I follow the following steps. 

1. Export the data in to Excel from the cloud source,

2. Save it to OneDrive,

3. Open Query Editor and replace the file path for the new Excel data. 

4. Save and Publish it Power BI Service replacing the previous report.

From the service version, I see that my data is refreshed and can see KPIs changed. However, I want to schedule refresh it by installing gateway connection, but the gateway installation failed. The error just shows it failed. My guess is because I don't have the Admin status. As a result, I am currently using the above manual steps to refreh my report weekly. Please let me know if I am doing right, missing anything important step, together with your best practices. 

Thanks