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

MMPB 120 Reputation points
2023-04-20T06:58:58.2433333+00:00

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?

Microsoft 365 and Office | Development | Other
Microsoft 365 and Office | Excel | For business | Windows

12 answers

Sort by: Most helpful
  1. Shubhabrata Dey 20 Reputation points
    2026-11-16T12:42:11.2966667+00:00

    Can anyone comment whether this issue persists still in Nov 2026?

    Was this answer helpful?

    0 comments No comments

  2. Phyo | Skyloov 0 Reputation points
    2025-10-15T15:15:31.9133333+00:00

    Same issue happens again in 2025. Looking for solutions...It's was working fine before

    but now workbook.refreshAllDataConnections() did not refresh at all.

    Was this answer helpful?


Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.