I have an excel file with connections that I want to refresh daily, automatically.
I wrote the simple one-liner script to refresh the connections and was running the script daily without error for a few months, and then recently in the last 2 weeks, the script has stopped working, and yields a non-specific error in Power Automate whenever it is run.
``` Excel Online Script
function main(workbook: ExcelScript.Workbook) {
// Refresh all data connections
workbook.refreshAllDataConnections();
}
```
I also deleted the script and started fresh with the macro recording of clicking the `Refresh All Connections` button to confirm it was the same function to use.
In Power Automate, whenever I try to schedule running the script, either by making the flow myself or by using the built-in option to schedule this script, I receive the following error message, with no logs attached.
{
"message": "We were unable to run the script. Please try again.\nOffice JS error: Line 3: Workbook refreshAllDataConnections: There was an internal error while processing the request.\r\nclientRequestId: $ClientID",
"logs": []
}
Is there any solution or known outage of being able to refresh data connections on a schedule?
Thanks in advance for any assistance.