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: Newest
  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. 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

  3. Jasper Z 0 Reputation points
    2025-11-19T09:26:11.5566667+00:00

    People are wondering why refreshAllDataConnections has been broken for so long. To me, the reason seems pretty obvious. Microsoft really doesn’t want us using Excel as a “middle tier” for pulling data from other sources. They’d much rather push us towards all the fancy connectors that can do the same thing in a more “official” way. The catch, of course, is that those connectors require a Premium license.

    Using Excel as a staging layer is effectively a workaround that avoids those Premium connectors (and the associated costs!) Breaking this path, while keeping the Premium route open, looks a lot like a deliberate push towards more expensive subscriptions and making previously working functionality unreliable or unusable. At best that’s questionable, but if you think it through, it’s pretty disgusting.

    So let’s not kid ourselves. I seriously doubt this function will ever be properly fixed. And now we’re seeing alternative routes, like Run script from SharePoint library, quietly stop working as well. Coincidence? Maybe. But it does fit the pattern.

    In the end, the choice is simple. Either swallow the Premium costs, or as an organisation start asking whether it still makes sense to keep pouring money into a company that clearly optimises for shareholders first, and for its actual users a distant second.

    Was this answer helpful?

    1 person found this answer helpful.

  4. 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?


  5. Adele Dong 10 Reputation points
    2025-09-09T01:54:07.9633333+00:00

    Same issue happens again in 2025. Looking for solutions...

    Was this answer helpful?

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