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: Oldest
  1. Moreno Martin Maria Angeles 10 Reputation points
    2025-11-20T17:06:39.89+00:00

    Hi , still happening in November 2025, any news?

    Was this answer helpful?

    3 people found this answer helpful.
    0 comments No comments

  2. 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

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.