Excel Power Query Not Refreshing on Virtual Machine

Is this modern Excel versions?

Yes, it’s using the most recent desk top version, using Excel Advanced actions in AA

Pls check your Connect query which using from Excel to database.

Put error handle and chek the bot in unattended mode

For my excel files which need power query refreshes, I have had to use macros to do the refresh.

This was mainly for the fact that Automation Anywhere was not aware of when the “refresh all” process completed, so I could not rely on that to continue without manually adding delays.

If you run a macro to do this, the bot will become aware of when it completes.

My macro has inputs for unprotecting/protecting the workbook, but you could remove these steps.

Sub RefreshmyQuery(ByVal sPassword As String)
Sheets("Terminated_User_Report").Unprotect Password:=sPassword
ActiveWorkbook.Connections("Query - Terminated_User_Report").Refresh
ActiveWorkbook.Connections("Query - Unique_Header_Records").Refresh
ActiveWorkbook.Connections("Query - Supervisor_List").Refresh
Sheets("Terminated_User_Report").Protect Password:=sPassword, DrawingObjects:=True, Contents:=True, Scenarios:=True _
        , AllowFormattingCells:=True, AllowFormattingColumns:=True, _
        AllowFormattingRows:=True, AllowSorting:=True, AllowFiltering:=True
ActiveWorkbook.Protect Password:=sPassword, Structure:=True
End Sub