Showing results for 
Search instead for 
Did you mean: 
Helper I
Helper I

Running office script with Workbook.refreshAllDataConnections() does not work when called from Power Automate



I use Power automate to refresh an excel table that is connected to Power BI every day.

This is via a 'Run Script' prompt that refers to a script containing Workbook.refreshAllDataConnections().


As of wednesday may 10th I receive the below error message:

Office JS error: Line 4: Workbook refreshAllDataConnections: There was an internal error while processing the request. clientRequestId: a7b48e93-4b3b-4db6-93a2-56378d34dd67

-> the script does work within excel (or excel online) itself.


I had priorly had a similar problem as now. This was then resolved, but I think the issue has come back.


Do others have this issue as well?






Thank you for the help.

Helper I
Helper I

If you are trying to load data from a Power BI report this may work for you.

Create a 2nd Power BI report and import the data from the first report using a DAX import query.

AnalysisServices.Database("powerbi://", "ReportName", [Query="EVALUATE tableName", Implementation="2.0"])

Link your Excel file to the new Power BI report instead.

This worked for me on a file I have had a lot of problems with in the past. I assume it works as Power BI is doing the calculations during the import of 2nd report leaving Excel to retrieve the data as it is.

Interested to hear if this works for others too.


@retrohead thanks for the callout! Yes, as the Office Scripts documentation points out, at this moment refreshAllDataConnections only works when PowerBI is the source: Troubleshoot Office Scripts running in Power Automate - Office Scripts | Microsoft Learn.


I will amend my last reply to include this callout in case using PowerBI as source might help some of the folks.

Helper I
Helper I

Thanks @Yutao To be clear this was my setup before that was not working:

Power BI -> Excel (Heavy DAX Calculations) -> Power Automate

This is the setup now

Power BI -> Power BI (Heavy DAX Calculations) -> Excel -> Power Automate

The exact same data file is now refreshing correctly, I just need to get the timing right on my refresh intervals.

Interested to see if others can get it working by doing this too. That may mean the DAX calculations is the part causing the problem here.

This is great if I were using DAX or anything that needed power BI. I hope it helps others that find this post.  (this sounds snarky. I can't help it. it's not. )
I am just trying to refresh a connection to a CSV at our data center, on a data sheet with some real basic calculations.  
I have three of these.  There is a CSV that is posted after hours.  And my little reporting sheets on Onedrive are connected with Power Query and until recently ran a refresh all script at 5, 6 and 7 am.  It was glorious and I miss the good times.  

but ya.  They are not going to give me PowerBI.  😞 

@TravisCB1 Sorry to hear the frustration. I can totally understand. I also hope we can get it working soon so we would have many happy customers instead of annoyed ones...


So it seemed the refreshAllDataConnections API indeed had worked for you previously, right? I may need to double check but I always thought this API should have never worked unless you are using Power BI. Although it's possible that I might have mixed it up with some other scenarios.

Advocate I
Advocate I

@Yutao Here is what was set up before. 
1. There is an excel macro with "refresh all" as its first step saved to a scripts folder on onedrive. 

2. The excel spreadsheets are saved in a Sharepoint folder.

3. A power automate script runs the macro on the excel spreadsheet on Mondays. 

The result was it would run the refresh, then a series of copy and paste actions, save an archive, then email a link to a group. 


Since this started, it runs, does not refresh all, then does all the copy pastes, makes a mess of the data, archives the mess then emails the mess to the group. 

Best Monday ever the first time... Better Monday the second time. I have since paused the script. I come in at 5AM on Mondays now and run the script.  As long as I open the file its fine.  the refresh happens, the copy pastes, everything.  It's just when power automate runs it. 

If you need more details, please feel free to ask, I will help any way I can. 

Advocate I
Advocate I

Any word? I have a meeting coming up, and even if there is an update of "no updates" that helps me. 


We have been making progress but unfortunately ran into a blocker and are still working on it. So sorry no we are not there yet but getting closer now.

Advocate I
Advocate I

That is better news than I was expecting.  Thank you. 

New Member


Anyone solve this challenge?

Doesn't look like it. Feels a little like they are planning on just letting it go.  😞
I gave up completely. I still couldn't get them to get me powerBi.  I am manually coming in early to update every Monday, while they look into other vendors for reporting. 😞

Responsive Resident
Responsive Resident

I am posting this here because my issue is relevant to this.


I have a script in my Excel file which uses workbook.refreshAllDataConnections(). If I run the script with the file open, it gets all my data so I know that the script works. When I use "Run script" in a basic Automate flow, the flow runs successfully but when I open my file, there is no new data. I am using the same user account everywhere and there are no errors.


Is this Automate feature still just broken?

@Yutao- Any update?

Still broken and I doubt it will ever be fixed. I have gone back to doing everything manually and requested that replace MS for this kind of work.

For me it does work again. You might want to check your authentication settings or reducing the file size as I mentioned in my previous comments.

New Member

This is NOT working for me - I have checked authentication settings and my file sizes are small (under 100k).  Waiting on an update from Microsoft on re-enabling this functionality.

Responsive Resident
Responsive Resident

This article explains the limitations:
Troubleshoot Office Scripts running in Power Automate 



Well after months, it seems you found the answer. 😞

Hi @rwittels, I'm currently encountering the exact same issue. Have you managed to overcome it?

Our company gave up. We are doing it manually until we find a new solution that is not Microsoft.

Responsive Resident
Responsive Resident

Hi. See my post above. It is only supported when PowerBI is the data source.

Helpful resources


Celebrating the May Super User of the Month: Laurens Martens

  @LaurensM  is an exceptional contributor to the Power Platform Community. Super Users like Laurens inspire others through their example, encouragement, and active participation. We are excited to celebrated Laurens as our Super User of the Month for May 2024.   Consistent Engagement:  He consistently engages with the community by answering forum questions, sharing insights, and providing solutions. Laurens dedication helps other users find answers and overcome challenges.   Community Expertise: As a Super User, Laurens plays a crucial role in maintaining a knowledge sharing environment. Always ensuring a positive experience for everyone.   Leadership: He shares valuable insights on community growth, engagement, and future trends. Their contributions help shape the Power Platform Community.   Congratulations, Laurens Martens, for your outstanding work! Keep inspiring others and making a difference in the community!   Keep up the fantastic work!        

Check out the Copilot Studio Cookbook today!

We are excited to announce our new Copilot Cookbook Gallery in the Copilot Studio Community. We can't wait for you to share your expertise and your experience!    Join us for an amazing opportunity where you'll be one of the first to contribute to the Copilot Cookbook—your ultimate guide to mastering Microsoft Copilot. Whether you're seeking inspiration or grappling with a challenge while crafting apps, you probably already know that Copilot Cookbook is your reliable assistant, offering a wealth of tips and tricks at your fingertips--and we want you to add your expertise. What can you "cook" up?   Click this link to get started:   Don't miss out on this exclusive opportunity to be one of the first in the Community to share your app creation journey with Copilot. We'll be announcing a Cookbook Challenge very soon and want to make sure you one of the first "cooks" in the kitchen.   Don't miss your moment--start submitting in the Copilot Cookbook Gallery today!     Thank you,  Engagement Team

Announcing Power Apps Copilot Cookbook Gallery

We are excited to share that the all-new Copilot Cookbook Gallery for Power Apps is now available in the Power Apps Community, full of tips and tricks on how to best use Microsoft Copilot as you develop and create in Power Apps. The new Copilot Cookbook is your go-to resource when you need inspiration--or when you're stuck--and aren't sure how to best partner with Copilot while creating apps.   Whether you're looking for the best prompts or just want to know about responsible AI use, visit Copilot Cookbook for regular updates you can rely on--while also serving up some of your greatest tips and tricks for the Community. Check Out the new Copilot Cookbook for Power Apps today: Copilot Cookbook - Power Platform Community.  We can't wait to see what you "cook" up!    

Welcome to the Power Automate Community

You are now a part of a fast-growing vibrant group of peers and industry experts who are here to network, share knowledge, and even have a little fun.   Now that you are a member, you can enjoy the following resources:   Welcome to the Community   News & Announcements: The is your place to get all the latest news around community events and announcements. This is where we share with the community what is going on and how to participate.  Be sure to subscribe to this board and not miss an announcement.   Get Help with Power Automate Forums: If you're looking for support with any part of Power Automate, our forums are the place to go. From General Power Automate forums to Using Connectors, Building Flows and Using Flows.  You will find thousands of technical professionals, and Super Users with years of experience who are ready and eager to answer your questions. You now have the ability to post, reply and give "kudos" on the Power Automate community forums. Make sure you conduct a quick search before creating a new post because your question may have already been asked and answered. Galleries: The galleries are full of content and can assist you with information on creating a flow in our Webinars and Video Gallery, and the ability to share the flows you have created in the Power Automate Cookbook.  Stay connected with the Community Connections & How-To Videos from the Microsoft Community Team. Check out the awesome content being shared there today.   Power Automate Community Blog: Over the years, more than 700 Power Automate Community Blog articles have been written and published by our thriving community. Our community members have learned some excellent tips and have keen insights on the future of process automation. In the Power Automate Community Blog, you can read the latest Power Automate-related posts from our community blog authors around the world. Let us know if you'd like to become an author and contribute your own writing — everything Power Automate-related is welcome.   Community Support: Check out and learn more about Using the Community for tips & tricks. Let us know in the Community Feedback  board if you have any questions or comments about your community experience. Again, we are so excited to welcome you to the Microsoft Power Automate community family. Whether you are brand new to the world of process automation or you are a seasoned Power Automate veteran - our goal is to shape the community to be your 'go to' for support, networking, education, inspiration and encouragement as we enjoy this adventure together.     Power Automate Community Team

Hear what's next for the Power Up Program

Hear from Principal Program Manager, Dimpi Gandhi, to discover the latest enhancements to the Microsoft #PowerUpProgram, including a new accelerated video-based curriculum crafted with the expertise of Microsoft MVPs, Rory Neary and Charlie Phipps-Bennett. If you’d like to hear what’s coming next, click the link below to sign up today!  

Tuesday Tip | How to Report Spam in Our Community

It's time for another TUESDAY TIPS, your weekly connection with the most insightful tips and tricks that empower both newcomers and veterans in the Power Platform Community! Every Tuesday, we bring you a curated selection of the finest advice, distilled from the resources and tools in the Community. Whether you’re a seasoned member or just getting started, Tuesday Tips are the perfect compass guiding you across the dynamic landscape of the Power Platform Community.   As our community family expands each week, we revisit our essential tools, tips, and tricks to ensure you’re well-versed in the community’s pulse. Keep an eye on the News & Announcements for your weekly Tuesday Tips—you never know what you may learn!   Today's Tip: How to Report Spam in Our Community We strive to maintain a professional and helpful community, and part of that effort involves keeping our platform free of spam. If you encounter a post that you believe is spam, please follow these steps to report it: Locate the Post: Find the post in question within the community.Kebab Menu: Click on the "Kebab" menu | 3 Dots, on the top right of the post.Report Inappropriate Content: Select "Report Inappropriate Content" from the menu.Submit Report: Fill out any necessary details on the form and submit your report.   Our community team will review the report and take appropriate action to ensure our community remains a valuable resource for everyone.   Thank you for helping us keep the community clean and useful!

Top Kudoed Authors
Users online (2,659)