Run Office Script: We were unable to run the script. Please try again.

(1) Share

Report

Posted on by RB-14081301-0

Hi everyone,

I’m experiencing inconsistent behavior when using the “Run Office Script” connector in Power Automate to refresh a pivot table that sources its data from Power BI. My flow sometimes fails with a 502 Bad Gateway error, while at other times, it runs successfully without any issues. Below is the code for my Office Script:

function main(workbook: ExcelScript.Workbook) {
workbook.refreshAllDataConnections();
}

This flow is critical as it’s used to send daily reports, so stability is essential.

Has anyone encountered similar issues? What steps can I take to prevent these intermittent failures and ensure that the flow runs reliably every day?

Thanks in advance for your help!

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

trice602 15,404 Super User 2025 Season 2 on at

Like (0)

Report

Hi,

In my experience what I have seen when this occurs is that it is not necessarily the Run Script action failure but rather one of the connections inside your workbook did not successfully connect or timed out and that's why you see inconsistency in the results. If you see that a resubmit does in fact refresh on later attempts, a good workaround is to configure a run-after on error and resubmit.

------------------------------------------------

⭐ If this was helpful, please like and/or mark as a verified answer to help others find this too!

Always glad to help! 💯💯💯💯💯

Tom

Follow me on LinkedIn - Thomas Rice, PMP | LinkedIn

Was this reply helpful? Yes No
trice602 15,404 Super User 2025 Season 2 on at

Like (0)

Report

Hey there!

I am following up on this post run office script: we were unable to run the script. please try again. in this category general discussion from 08/14/2024. I know the post is a little older, but it is a common question here so wanted to take a moment and follow-up. I see there have been 1 replies and 1 likes and asking if your question has been answered. If so, please help the community out by completing one or more of the following actions! Thanks in advance!

Easy as 1-2-3 ‼️💯⭐😎🆒🙏

1) Mark a reply as a verified answer - this is essential, and it helps others with the same general question find this thread. ✅

2) You can also mark one of more replies as a verified answer. Please take a moment and give the author credit for volunteering their time. ✌️

3) Like one or more replies. Kudos always greatly appreciated! 👍

Pro tip: if you found your own solution or workaround, feel free to add a reply to your own post and mark it as the solution too! The goal is to get this thread marked with a verified answer by anyone that finds one or more replies helpful!

Again, thanks in advance for reading and responding, always glad to help! Tom 💯💯💯💯💯

Was this reply helpful? Yes No
trice602 15,404 Super User 2025 Season 2 on at

Like (0)

Report

If I can help with anything else please let me know or tag me in a future post, I enjoy reading and answering questions. Always glad to help! Tom 💯💯💯💯💯

Was this reply helpful? Yes No