I’m using the Advanced Excel action in a bot. The Excel file contains a Power Query that is set to automatically refresh on opening.Here’s the issue:When I run the bot on a virtual machine as a scheduled unattended bot, the Power Query does not refresh automatically. I tried simulating keystrokes (using the keyboard shortcut for refresh), but that doesn’t work either. Permissions are set at the organizational level. Interestingly, when I’m logged in and testing manually on the VM, the refresh works fine. The problem only occurs during scheduled runs.Has anyone encountered this before? Is there a workaround to ensure the Power Query refreshes when the bot opens the file during a scheduled run?Thanks in advance for any suggestions!

Question

Excel Power Query Not Refreshing on Virtual Machine

+2

I’m using the Advanced Excel action in a bot. The Excel file contains a Power Query that is set to automatically refresh on opening.

Here’s the issue:

When I run the bot on a virtual machine as a scheduled unattended bot, the Power Query does not refresh automatically.
I tried simulating keystrokes (using the keyboard shortcut for refresh), but that doesn’t work either.
Permissions are set at the organizational level.
Interestingly, when I’m logged in and testing manually on the VM, the refresh works fine. The problem only occurs during scheduled runs.

Has anyone encountered this before? Is there a workaround to ensure the Power Query refreshes when the bot opens the file during a scheduled run?

Thanks in advance for any suggestions!