Skip to main content

Notifications

Power Automate - Building Flows
Unanswered

Scheduled Connection Refresh from Excel Online Script -> Power Automate stopped working

(1) ShareShare
ReportReport
Posted on by 2
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.
  • bcobra42 Profile Picture
    bcobra42 24 on at
    Scheduled Connection Refresh from Excel Online Script -> Power Automate stopped working
    try   workbook.refreshAllDataConnections;  (get rid of the parenthesis) --nevermind this doesnt run the actual function its just gets skipped without error

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,691

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 65,019

Leaderboard