Hello, I have an Excel script that will refresh all data connections within the file. I am using Get Data->Excel file to pull in another Excel file I need. I have tested the script and it works perfectly. I need to be able to have this script run in the background of when I am away from my laptop, so I have tried to use Power Automate to run the script in my Excel file every X minutes. My power automate flow is simple: Recurrence->Run Script. I have been testing my Power Automate flow and been getting success messages, but when I open up the Excel file I do not see any updated data on the data table that is supposed to there. I do not think this is a script issue, because in my script I even included a log of time for when the script runs successful, and it will update each time I initiate the Power Automate flow, but the data will still not be refreshed. I do not understand why my flow and script will seem to be run correctly, but the data connections will not be refreshed.

​Hello, I have an Excel script that will refresh all data connections within the file. I am using Get Data->Excel file to pull in another Excel file I need. I have tested the script and it works perfectly. I need to be able to have this script run in the background of when I am away from my laptop, so I have tried to use Power Automate to run the script in my Excel file every X minutes. My power automate flow is simple: Recurrence->Run Script. I have been testing my Power Automate flow and been getting success messages, but when I open up the Excel file I do not see any updated data on the data table that is supposed to there. I do not think this is a script issue, because in my script I even included a log of time for when the script runs successful, and it will update each time I initiate the Power Automate flow, but the data will still not be refreshed. I do not understand why my flow and script will seem to be run correctly, but the data connections will not be refreshed.  Read More

​