Forum Discussion
Refresh power query without opening file
Good afternoon, I would like to update my power query without having to be in the file to trigger the refresh. I have excel workbooks that live inside share point. I would like the power query to ...
It depends. If new row of data is added by Power Automate, you may generate RefreshAll Office Script and run it also by Power Automate. But so far that works only if the data source is within same file. RefreshAll on web doesn't work with external sources.
Otherwise perhaps something with Power Shell which opens the file, refresh data and close the file after that.
Sergei, thank you for your response. I will look into office script tools.