I am pulling Salesforce objects data via power query into an Excel 365 file kept in a sharepoint folder. Right now, to update the file at scheduled times, i have to open the online file in Excel App, refresh power query, then do some manipulations, calculations to the sheets and then save and close it. What i want to do is automate it:
Trigger multiple hourly/daily/weekly refreshes to Salesforce data.
Can someone help here on how this can be achieved?