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

MMPB 80

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 30 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 0 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 20 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
Ryan Bettilyon 45 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
Rodolphe F 5 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.
Usama Waheed 15 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.
THU YAIN KO, P456SR 0 Reputation points

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

Hello, have you find any solution to this problem?
Pete 5 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!

13 answers

Alan Cussen 20 Reputation points

2023-04-20T20:10:17.29+00:00

I'm calling an Office Script from my flow. I got the same failure message this morning. I just dropped the "()" and my flow ran successfully again. <br> So change from this: workbook.refreshAllDataConnections()

to this: workbook.refreshAllDataConnections
Please sign in to rate this answer.

2 people found this answer helpful.
Joachim 30 Reputation points

2023-04-21T06:45:00.11+00:00

That takes the error away, but I don't think the refresh works when I do that?

EMS 0 Reputation points

2023-04-24T21:58:58.8333333+00:00

Joachim - Same here. Runs. No refresh

Yutao Huang - MSFT 701 Reputation points Microsoft Employee

2023-04-25T00:00:24.23+00:00

Hey folks! Can you help to confirm if the call to workbook.refreshAllDataConnections() is working now? Please note currently the refresh API only refreshes Power BI data connections.
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.
Yutao Huang - MSFT 701 Reputation points Microsoft Employee

2023-04-24T16:00:52.3666667+00:00

Apologize! This was indeed a regression on our side, and it should be fixed now. Please let us know if you are still having issues with refreshing Power BI data connections. Thanks for your patience and support!
Please sign in to rate this answer.

2 people found this answer helpful.
AKV 20 Reputation points

2023-05-24T07:53:29.08+00:00

Hi Yutao, still having issues with running the below script via PowerAutomate. Says the flow has run but no change to the data in the workbook. The fix you talk about, is that the script failure being fixed or an action to refresh excel file in PowerAutomate being added?

Refreshing a workbook from PowerAutomate as an Action should be a minimum requirement for the PowerAutomate system in my opinion.

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

Gerard Brown 0 Reputation points

2023-06-03T17:02:01.1766667+00:00

Same - I still can't figure out how to refresh my excel data connections via Powe automate.

CongHauLe-8298 0 Reputation points

2023-07-18T09:20:02.68+00:00

The issue still exist till now :((

Aritra De 0 Reputation points

2024-05-23T08:33:41.1933333+00:00

Still I am unable to refresh the script. the script runs sometimes but fails most of the time.

Martin Borst 0 Reputation points

2024-06-25T13:45:17.6666667+00:00

I am still facing the issue

Alexis Arteta 0 Reputation points

2024-09-26T21:14:11.9533333+00:00

I'm too got the same problem
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.
Shubhabrata Dey 10 Reputation points

2023-07-19T12:30:28.37+00:00

Hi All,

I too had the same issue. Recently I have come across with the below link from Microsoft which says Power Automate will not support RefreshAll action. Refer the below link:

https://video2.skills-academy.com/en-us/office/dev/scripts/testing/power-automate-troubleshooting

I sincerely hoped such simple stuffs should have been covered by Microsoft ages ago.
Please sign in to rate this answer.

2 people found this answer helpful.

0 comments No comments
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.
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.
Please sign in to rate this answer.

1 person found this answer helpful.

0 comments No comments
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.
Jaywant Ashok Thorat 0 Reputation points

2023-04-20T08:14:13.9133333+00:00
It seems like the issue you are facing is related to the limitations of using the refreshAllDataConnections() method in Power Automate. Since this method is not supported in Power Automate, you need to use a different approach to refresh the workbook data before running the Power Automate Flow. One possible workaround is to use the "Refresh Workbook" action in Power Automate before running your script to send notifications. Here's how you can do it:

Open your Power Automate Flow and add the "Refresh Workbook" action from the Excel Online (Business) connector.

In the "File URL" field, select the Excel file that you want to refresh.

Click on "Save" to save the changes. Once you have added the "Refresh Workbook" action to your Flow, it should refresh the data in your Excel file before running the script to send notifications. Please note that this approach may take some time to refresh the data, depending on the size of your Excel file and the amount of data that needs to be refreshed. You can also add a delay action before running the script to allow time for the data to be refreshed.
Please sign in to rate this answer.
MMPB 80 Reputation points

2023-04-20T09:36:59.1466667+00:00

Dear Jaywant, thanks for our help.
This sounds like a solution for my problem.
But I can't find the refresh action

MMPB 80 Reputation points

2023-04-20T09:37:47.7066667+00:00

PauloGoncalves-9960 0 Reputation points

2023-04-20T09:43:30.8633333+00:00

Same issue here. flow worked fine until today. Also can't find the "Refresh Workbook" action in Power Automate

Bolsée Jamar de, Louis 10 Reputation points

2023-04-20T12:39:47.46+00:00

Same issue, the refresh workbook doesn't exist on my side either..

Tyler Graham 1 Reputation point

2023-04-20T18:42:19.5566667+00:00

Same problem here. Weekly report failed because of this error. I also do not have a "Refresh Workbook" action available. Back to the drawing board. What did Microsoft do to cause this? Probably some UI update.
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.

13 answers

Your answer