Workbook.refreshAllDataConnections() is not supported in Power Automate.

MMPB 110

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?

Joachim 35 Reputation points

2023-04-20T09:09:40.63+00:00

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 Ashok 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.
Gerard Brown 5 Reputation points

2023-04-20T14:09:36.0133333+00:00

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 Ashok Thorat found that solution since I can't in the actions either.
Alan Cussen 35 Reputation points

2023-04-20T17:33:08.2533333+00:00

I dropped the "()" and my flow ran successfully again.

So change from this: workbook.refreshAllDataConnections()

to this: workbook.refreshAllDataConnections
Ronny Alexander Peralta Sanchez 0 Reputation points

2023-04-20T18:41:43.7766667+00:00

Hello, dear Did you find any solution to this problem?
I'm getting the same issue, and i can't find the "Refresh Workbook" in Power Automate My flow worked fine until today.
MMPB 110 Reputation points

2023-04-24T08:36:49.02+00:00

@Ronny Alexander Peralta Sanchez No, i am still searching. If you found a solution please inform me too.
Ryan Bettilyon 50 Reputation points

2023-05-17T20:59:30.7+00:00
@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:

Running the Flow that includes an Excel (Business) Run Script step with the Automation Script defined in the Excel file (which is hosted in SharePoint online):

function main(workbook: ExcelScript.Workbook) { // Refresh all data connections workbook.refreshAllDataConnections(); }

This results in the following Error Details:

We were unable to run the script. Please try again. Office JS error: Line 3: Workbook refreshAllDataConnections: There was an internal error while processing the request. clientRequestId: fd28ea8d-edbe-4c75-a6a4-2b6e3879c42b

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
Dennis-2732 0 Reputation points

2023-09-27T08:19:54.3466667+00:00

Is there already a solution to the problem ?

Has there been an answer from the Microsoft team when the problem will be fixed?
Carlos Renato Rodrigues 0 Reputation points

2023-09-27T13:07:11.95+00:00

Hello,

Is there an alternative to refresh only a specific sheet?

BR

Carlos
Travis Webb 5 Reputation points

2023-09-27T14:17:54.1066667+00:00

This is the main reason I used PA and this has been a trainwreck for me.
Rodolphe F 20 Reputation points

2024-04-04T15:38:08.8566667+00:00

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.
Rodolphe F 20 Reputation points

2024-04-04T15:39:20.4566667+00:00

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!
Usama Waheed 20 Reputation points

2024-07-14T16:47:32.3866667+00:00

July 2024 and I am also facing the same issue. Even in Excel Online, workbook.refreshAllDataConnections() has stopped working of all of a sudden.

When I first created the Power Automate Flow, it worked fine and test was succeesful. The above command was working in Excel Online as well (Office script). But then it stopped working in Power Automate all of sudden with error message "We were unable to run the script. Please try again. Office JS error: Line 3: Workbook refreshAllDataConnections: There was an internal error while processing ...". I then checked the office script in excel online and it was not doing anything there as well although it was giving no error there.
I have also tried removing '()' but this only makes the error message disappear. The required action of refreshing the file is still not occurring.
Any help in this regard would be much appreciated.
Usama Waheed 20 Reputation points

2024-07-14T16:50:00.1466667+00:00

Hello
Hope you are having a good day.
Any chance you were able to resolve this issue?
Thu Yain Ko 0 Reputation points

2024-08-22T02:27:24.82+00:00

Hello, have you find any solution to this problem?
Pete 25 Reputation points

2024-10-18T09:29:41.97+00:00

Bumping this - has anyone found a solution? As another commentor said, its such a fundamental requirement, surpised this hasn't been looked at in the last couple of years!
Pete 25 Reputation points

2024-10-18T09:30:24.3166667+00:00

Bumping this - has anyone found a solution? As another commentor said, its such a fundamental requirement, surpised this hasn't been looked at in the last couple of years!
Lakshmikanth Krishnachar 0 Reputation points

2024-10-23T18:41:03.71+00:00

Spent months on this issue. Tried all including delays, running script from sharepoint etc. Nothing works but sometime works and then stops. Looking for an solution
Gerald Herman 0 Reputation points

2024-11-05T14:30:02.0933333+00:00
What finally worked for me was to have the connection property 'Refresh this connection on Refresh All' checked. The connection properties are only accessible from the app view.

In power automate, only the Run script from SharePoint library worked for me. The Run Script Action did not. I prefer this in any case, as I would like to start parameterizing / reusing these scripts and story in a SharePoint library where I can protect them from changes.

This was my script.

function main(workbook: ExcelScript.Workbook) { workbook.refreshAllDataConnections(); }
Gerald Herman 0 Reputation points

2024-12-02T15:09:15.8733333+00:00

Make sure the 'Refresh the connection on Refresh All' is checked in the Connection Properties of the connection.
Richard Sparey 0 Reputation points

2025-03-16T20:11:08.6066667+00:00

Same issue in March 2025.

Script works when I run it in excel, but in Power Automate, the flow successfully runs but the connections do not update.

Does anyone have a solution yet?
B.Cobra 10 Reputation points

2025-03-17T06:13:01.25+00:00

We have an ongoing ticket in with MS. they have patched this several times over the last few months, but it always breaks. They said they hope to have a fix in about 3 months.
Richard Sparey 0 Reputation points

2025-03-17T08:12:18.2266667+00:00

Thanks B.Cobra. Will be glad when it's fixed, but how can it be trusted if it continues to fail. I won't even know if it fails unless I'm reviewing the data everyday (wasn't PA created for such tasks though).

I'll use PA Desktop with a macro for now, but this isn't ideal.
Richard Sparey 0 Reputation points

2025-03-17T10:47:03.5133333+00:00

I created a flow through desktop to open file, refresh connections, refresh pivots, then close.

The file opened and closed before anything was actioned. By putting a delay after each refresh, it allowed the flow to catch up. Could this be the reason why PA online is having problems?

If anyone from MS sees this, please review this issue again. Thanks
Rodolphe F 20 Reputation points

2025-03-19T13:43:35.4933333+00:00

It has been 2 years now that Workbook.refreshAllDataConnections() hasn't been working on Online Power Automate and Excel !

7 answers

Fabio Plos 0 Reputation points

2023-10-17T23:28:24.3+00:00
it seems that for now the only solution is:

Select Data > Queries & Connections > Connections tab, right click a query in the list, and then select Properties.

Click the Usage tab.

Select the Refresh every check box, and then enter the number of minutes between each refresh operation.

fyi 1440 minutes is one day

repeat for all connections
Please sign in to rate this answer.

0 comments No comments
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.
Dung Thuy Nguyen 0 Reputation points

2023-12-05T07:51:10.57+00:00

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
Please sign in to rate this answer.

0 comments No comments
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

Workbook.refreshAllDataConnections() is not supported in Power Automate.

7 answers

Your answer