This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(198.4, 22%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EM%3C/text%3E%3C/svg%3E)
Dear all,
I have an excel sheet with an active connection which I am able to refresh to get the newest data.
Now I've got another PowerAutomate Flow which is working fine with a script inside this Sheet to send me via Teams numbers which I want to be notified about.
Unfortunately it only works if I am updating the workbook manually via Data-Refresh all, or if I am executing the script inside The workbook via automate this code line works:
"workbook.refreshAllDataConnections();"
It is now also possible to test the flow in Powerautomate and get all data (without the refresh code line).
With the refresh Code line I get this error message:
We were unable to run the script. Please try again.
Runtime error: Line 7: Workbook.refreshAllDataConnections() is not supported in Power Automate.
clientRequestId: 0b8eaf2a-1429-430a-8ae6-21fcf4330213
How can I refresh the workbook via Power Automate?
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(51.2, 35%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJ%3C/text%3E%3C/svg%3E)
I had the same issue and had also reported on it: https://powerusers.microsoft.com/t5/Using-Connectors/Running-office-script-with-Workbook-refreshAllDataConnections/m-p/2118970#M18064.
@Jaywant Thorat Can you please let me know what "refresh workbook" action you are referring to? workbook.refreshAllDataConnections() is the only way that I know of to refresh a workbook from Power Automate.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(243.2, 40%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGB%3C/text%3E%3C/svg%3E)
I'm having the same issue. workbook.refreshalldataconnections() was working just 2 weeks ago, so not sure what happened. I would also be interested in where @Jaywant Thorat found that solution since I can't in the actions either.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(83.2, 71%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAC%3C/text%3E%3C/svg%3E)
I dropped the "()" and my flow ran successfully again.
So change from this:
workbook.refreshAllDataConnections()
to this:
workbook.refreshAllDataConnections
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(140.8, 90%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERB%3C/text%3E%3C/svg%3E)
@Yutao Huang - MSFT I'm working on my first Power Automate Flow to refresh an Excel workbook, and came here to report that this still seems to be an issue. It's quite frustrating, as I'd imagine refreshing data in an Excel file is probably the most sought-after and basic type of Excel automation.
Here are the details:
function main(workbook: ExcelScript.Workbook) {
// Refresh all data connections
workbook.refreshAllDataConnections();
}
Note that when I attempted the tip from @Alan Cussen above (Omitting () from the workbook.refreshAllDataConnections command, the error message does not trigger (implying a successful run of the script) but the data refresh actually does not occur (the workbook data remains stale as it was prior to the Flow running).
Can you please advise on when this will be fixed, or any workarounds for triggering a workbook Refresh All command via Power Automate? Surely there must be a way to reliably accomplish this very basic automation.
Thank you,
-Ryan
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(150.4, 7.000000000000001%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERF%3C/text%3E%3C/svg%3E)
April 2023 and one year has passed. April 2024, still no solutions?
I have the same issue with a script containing : workbook.refreshalldataconnections() > nothing happens. No message of any error but none of my queries in Power Query have been refreshed at all. I tried without (): still don't work.
And of course the "refresh workbook" step in Power Automate doesn't exist. Totally fake.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(28.799999999999997, 87%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDT%3C/text%3E%3C/svg%3E)
This might be the reason: Currently Excel Online does not support refreshing data sources from Power Queries. It seems that Excel for Web only allows Odata or table/range.
If you build a new flow for Power Automate Desktop instead, it will be easier to consolidate Excel files
Same issue here! April 2023 and one year has passed. April 2024, still no solutions? I have the same issue with a script containing : workbook.refreshalldataconnections() > nothing happens. No message of any error but none of my queries in Power Query have been refreshed at all. I tried without (): still don't work. And of course the "refresh workbook" step in Power Automate doesn't exist. Totally fake.
Thanks for your help!