web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

Welcome to the Power Platform Communities
The Next Big Bite | Aussie Classics & Starting Small with Clay Wesener | EP04
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Refreshing excel data ...
Power Automate
Unanswered

Refreshing excel data in unattended mode (Power Automate desktop on virtual machine)

(0) ShareShare
ReportReport
Posted on by PawelRRR 23
 

Hello,

 

I have issue with refreshing all connections in Excel in unattended mode. Using PAD on virtual machine.

Tried already actions with send keys, run excel macro and PS script (screenshots below are related to this last scenario)

On attended mode each scenario worked fine. Refresh took few minutes.

 

PawelRRR_0-1715360447115.jpeg

 

 

 

On unattended mode with PAD scheduled flow its succeed with less than 1min:

PawelRRR_1-1715360447381.jpeg

 

Excel was saved via script but refresh has not been done/or stopped.. not sure how to debug it:

PawelRRR_2-1715360447123.jpeg

 

Connection is OLE DB type. (Connecting with Oracle DB and taking data, very simple SQL query)

PS script:

PawelRRR_3-1715360447384.jpeg

 

 

Please, can You advise where could be an issue and/or how I can debug the reason that its not refreshing in unattended mode?

I am fighting with this topic at least one week...

 

Thanks in advance for any advise/support on that!

Pawel

Categories:
Power Automate Desktop
I have the same question (0)
  • CU16071609-1 Profile Picture
    CU16071609-1 6,255 Moderator on at

    @PawelRRR 

     

    Attempt implementing a delay logic between different functions in PowerShell.

     

    Log all activities in a designated log file. Before refreshing the Excel file, check if the excel file is open. Based on this, incorporate appropriate logic to gain insights into your flow.

     

    Hope it helps!!

     

     

     


    Thanks,
    Deenuji Loganathan 👩‍💻
    Automation Evangelist 🤖
    Follow me on LinkedIn 👥

    -------------------------------------------------------------------------------------------------------------
    If I've helped solve your query, kindly mark my response as the solution ✔ and give it a thumbs up!👍 Your feedback supports future seekers 🚀

  • PawelRRR Profile Picture
    PawelRRR 23 on at

    Hello Deenuji,

     

    Thanks for reply. Unfortunately I have very basic knowledge regarding Powershell.. Can advise in more detailed way where exactly and what action You would add for delay in the script?

    I have added already 'start-sleep' action for waiting till refresh will be done.. but seems that sth is not working like I would except..

     

    Thanks in advance!

    Kind regards

    Pawel

     

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Welcome to the Power Platform Communities
The Next Big Bite | Aussie Classics & Starting Small with Clay Wesener | EP04

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 276 Super User 2026 Season 1

#2
11manish Profile Picture

11manish 169

#3
Haque Profile Picture

Haque 154

Last 30 days Overall leaderboard

Featured topics

Known issue with browser automation in Power Automate for Desktop on Google Chrome 146 and 147
Share your ideas and struggles with building Power Automate flows!
Survey: Power Automate mobile app
How to Ask for Help with Your Power Automate Workflow
Start and wait for an approval action
Restore a deleted flow
List of actions cheat sheet for Power Automate Desktop
Welcome to the Power Automate forum!

Product updates

Microsoft Power Platform Community release plans